Passing each Job Name as a paramter.

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kondeti
Premium Member
Premium Member
Posts: 67
Joined: Sat Mar 04, 2006 11:38 am

Passing each Job Name as a paramter.

Post by kondeti »

Dear All,
I created 2 jobs.

Background Information:
-- In my first job I am pulling all the existing jobs in the project into a .csv file, This job is producing almost all close to 1000 jobs information.
-- In my second job I am populating a dsjob report into a control table. "Second job suppose to take each "Job Name" as input"

Problem:
I am trying to pass each "Jobname" as parameter to my second job from first job output at runtime. I struck in middle of this logic implementation part. If anyone came across this situation or If you have any Idea on this can you please share your thoughts. Thank you.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

A Sequence job could run the first job and then use the csv file in the Start/End Loop stages to run the second job, once for each record in the file. That or perhaps UtilityRunJob() could be leveraged.
-craig

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