I have a sequence job which is callling 3 jobs in sequence. I have specified a OK condition on the first job activity trigger. When trying to run the sequence, the first job is finishing with warnings and even the sequence finishes with warnings ( It doesnt run the other two jobs in the sequence though!)
Is there any way to abort the sequence if any of the job activities finish with warnings!
Or how do i abort a job based on the job run status
How to abort the sequence
Moderators: chulett, rschirm, roy
How to abort the sequence
Regards,
Shree
785-816-0728
Shree
785-816-0728
Re: How to abort the sequence
The answer depends on your version of DataStage. For 7.5.x all you have to do enable the option to 'Automatically handle activities that fail'. If all you have is an 'OK (Conditional)' trigger then anything other than OK will be considered a failure and it will abort the Sequence. Combine that with the 'Add Checkpoints' option if you want to be able to pick up from the point of failure automatically.Sreedhar wrote:Is there any way to abort the sequence if any of the job activities finish with warnings!
For earlier versions it is a little bit more complicated.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers