How to abort sequencer only when all jobs finish during fail

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
HemaV
Participant
Posts: 63
Joined: Wed Jan 09, 2008 1:38 am
Location: Bangalore

How to abort sequencer only when all jobs finish during fail

Post by HemaV »

Hi All,

My Sequencer looks like:
Job1 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity1 and Terminator Activity1 to check for any ORA-ERROR
Job2 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity2 and Terminator Activity2 to check for any ORA-ERROR
Job3 Activity -> In job Triggers Custom-(Conditional) is selected for both Routine Activity3 and Terminator Activity3 to check for any ORA-ERROR

When i run my sequencer, Job1, Job2 and Job3 starts running parallely. Say Job3 finishes first and it immediately triggers Routine Activity3 which fails. At that time routine error message is written to error log file and immediately sequencer is aborted even without waiting for Job1 and Job2 to finish before aborting sequencer.

NOTE: In Terminator properties "Abort without sending STOP requests. and Wait for all jobs to finish first." is selected.

What needs to be done if i want my jobs to finish first before sequencer is aborted in above case?


Thanks in advance
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

There is no need to post the same question twice, it has been answered here.
Post Reply