Sequence - Please advice

Zabeerulla · Post by **Zabeerulla** » Thu Mar 30, 2006 12:06 am

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.

rasi · Post by **rasi** » Thu Mar 30, 2006 12:14 am

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

kumar_s · Post by **kumar_s** » Thu Mar 30, 2006 2:16 am

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

Zabeerulla · Post by **Zabeerulla** » Thu Mar 30, 2006 2:58 am

Thanks!

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

gateleys · Post by **gateleys** » Thu Mar 30, 2006 7:24 am

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