I have 25 parallel jobs that need to be executed in a order. Need a suggestion where i need not add 25 stages to the Sequncer job instead pass the parallel job name to one stage and get them executed.
Ranjan
Sequencer with few stage to call multiple parallel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Mon Apr 23, 2012 12:28 pm
Unfortunately, I can't think of a way to do that with different job names. If it were one job that is multi-instance then a sequece could loop through the instances, but that is not the case here.
If it is any consolation, I have a sequence right now that has over 60 different jobs and each of those has from 15-25 parameters that need to be filled in each time. It isn't a great job to fill that in, but needs to be done.
If it is any consolation, I have a sequence right now that has over 60 different jobs and each of those has from 15-25 parameters that need to be filled in each time. It isn't a great job to fill that in, but needs to be done.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could write your own Job Control routine. This is the old-fashioned way, and requires some skill with DataStage BASIC code, but may solve your particular problem.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 15
- Joined: Mon Apr 23, 2012 12:28 pm
You can't do it simply in a job sequence, since call to jobs in sequences are effectively hard-coded at compile-time.
There is the command-line "dsjob -run" invocation method which you could call from within a loop in a job sequence, or you could use the DataStage API BASIC calls directly in a loop as well.
There is the command-line "dsjob -run" invocation method which you could call from within a loop in a job sequence, or you could use the DataStage API BASIC calls directly in a loop as well.