Page 1 of 1

To run the sequences whose names are retrieved from file

Posted: Thu Nov 03, 2011 9:53 am
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,

Posted: Thu Nov 03, 2011 10:16 am
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.

Posted: Thu Nov 03, 2011 12:37 pm
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.

Posted: Thu Nov 03, 2011 1:06 pm
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 .