Job Sequencer

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
c341
Participant
Posts: 39
Joined: Mon Jan 26, 2004 8:43 pm

Job Sequencer

Post by c341 »

Hi
I have 9 job activity in a job sequencer and i have 4 routine activity for 4 jobs.
I 'm using this routine and if this routine executed then i have to trigger the job corresponding to the routine. The routine have a return value. In routine activity options i choosed OK-Executed Successfully Option.

EG:
In routine i'm returning a Timestamp value......
I have to pick the records greater than this date....

Now the problem is i'm not able to trigger all the job activities.
Its executing 3 routine activity and triggering the job and the data is picked that are greater than that date...
Other rouitnes are not executing....
So i used unconditional options int routine activity ..but it triggers before the routine completed....
If i create a separate job sequencer for each job....i can see the return value from the routine in the log(I'm using the return value in the update date parameter in the job) AND IT works fine...
but if i combine all in one job sequencer i'm not able to get the value...

How can check whether the routine is executed successfully or not...

Thank You - c341
Post Reply