To run the sequences whose names are retrieved from file

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Cherukuri
Participant
Posts: 46
Joined: Wed Jul 25, 2007 2:43 am
Location: India
Contact:

To run the sequences whose names are retrieved from file

Post by Cherukuri »

Hi,

I have a text file which contains the names of few job sequences new line delimiter.
Now I am developing a sequence job which will only run those sequences whose names are retrieved from the text file.

(i) I call an script which gives me the names of the sequences.
(ii) I store all the names of in UserVariable.
(iii) Then I start a loop activity which takes the names one by one.
(iv) I applied a job activity stage,but cannot get the value i.e the sequence name to run from the file in the Job Name tab of the job activity.


Could you please suggest me whether the design is correct or it has to be done in some other way?

Hope I am able to explain the requirement.

Thanks and Regards,
Cheru
BI-RMA
Premium Member
Premium Member
Posts: 463
Joined: Sun Nov 01, 2009 3:55 pm
Location: Hamburg

Post by BI-RMA »

Take a look at the Routine UtilityRunJob (Routines-->sdk-->Utility).

You can run this from a server job. Read your file with the job names, add parameters you need and provide these as input to the Routine.

Your jobs/sequences will then be executed sequentially by the server job.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Wrong forum. This forum is for posting suggestions for FAQ topics.

DataStage questions should be posted in the appropriate forum, so that we can gain some insight into which edition you're using and which version and platform.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Moved.

Cherukuri - please go back and edit your post to include the details we're missing right now: Version, Job Type & O/S .
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply