Need To Abort Master Sequence While Any Child Job Fails

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
Rubu
Premium Member
Premium Member
Posts: 82
Joined: Sun Feb 27, 2005 9:09 pm
Location: Bangalore

Need To Abort Master Sequence While Any Child Job Fails

Post by Rubu »

Hi

We are using a master sequenece to call many other sequences. All dependent sequences are triggered with OK--condition. But while Jobs fails inside CHILD sequence, it still triggers the next sequence, as the Job_Activity stage returns OK--for that seqence.

How can I trape only the abort situations for the jobs. While a job is aborted inside any child seq, the sequence should abort. Warning from job should not produce warnings for the sequence.

Thanks
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Call the DSLogFatal from a routine via the Sequencer. Alternatively use the corresponding "Utility" log fatal.
rajiivnb
Participant
Posts: 77
Joined: Fri Sep 10, 2004 8:38 am
Location: India

Need To Abort Master Sequence While Any Child Job Fails

Post by rajiivnb »

In child sequence, in the job properties --> peformance tab, click the
'Automatically handle activities that fail' check box, i hope this will solve ur problem. also in the master sequence click the 'Add checkpoints so sequence is restartable on failure' check box, it will make ur master sequence to start from the failure child sequencer..... this will solve ur problem.. The master sequence will say its finished, instead of abort. u can find which child sequence is aborted, it will show the aborted sequence.
Post Reply