DSXchange

Hi,

We are using DataStage 7.1. Consider the scenario.
1. I have a sequence with three jobs in which the second job runs after the first job returns job status = 1 or 2.
2. If the second job gets aborted then the sequence is getting completed and showing status as Finished.
I want the Sequence should show status Finished only when all the jobs are completed. If any one of the jobs fails the sequence should get aborted.

Hi

Have a custom conditional trigger on the three jobs to check the status of each job and send all three links to Routine Activity where you can call AbortJob Routine to abort you sequence

Dont you have the option 'Automatically Handle Activity that fails' in Job property?
If so check it.

Thanks!

Kumar, I checked the option "Automatically handle activities that fail" in the properties. Its working fine. Thanks

Zabeerulla wrote:Thanks!

Kumar, I checked the option "Automatically handle activities that fail" in the properties. Its working fine. Thanks

In case you are still stuck with version 7.0 or below and you don't have this feature, you can use the sequence design that I have described in the following post-
viewtopic.php?t=99484

gateleys