Stop a Sequence Job on Failure.

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Stop a Sequence Job on Failure.

Post by admin »

Hi,
I have 3 jobs in a sequencer Job. I noticed that if the 2nd job of the 3 fails, the sequencer finishes successfully with some info on the Job that failed and it does not run the following jobs. Is there a way to make it a failed sequencer job if any of the job fails and if i want to restart it, is there a way to restart the job from the one that failed? so it does not restart from the previous ones that were successful.

Thanks.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Stop a Sequence Job on Failure.

Post by admin »

You need to do something to directly cause it to fail.

One possibility is to output a failure link from each job to each routine
stage which calls UtilityAbortToLog() function.

-T.J.

>I have 3 jobs in a sequencer Job. I noticed that if the 2nd job of the 3
>fails, the sequencer finishes successfully with some info on the Job that
>failed and it does not run the following jobs. Is there a way to make it a
>failed sequencer job if any of the job fails and if i want to restart it,
>is there a way to restart the job from the one that failed? so it does not
>restart from the previous ones that were successful.

_________________________________________________________________
Is there a gadget-lover on your gift list? MSN Shopping has lined up some
good bets! http://shopping.msn.com
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked