DSXchange

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

You can set a conditional Trigger to "warnings" and then link this trigger to a Terminator Activity - which will then abort the job.

Do an exact search on "abort a job" you get many results.

As mentioned, search will give you many results. But why do you want to abort the sequence if it has stoped executing the rest of the Jobs?

Sreedhar wrote:Is there any way to abort the sequence if any of the job activities finish with warnings!

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.

For earlier versions it is a little bit more complicated.