Sequence job dependency

suryadev · Post by **suryadev** » Fri Nov 04, 2011 10:09 am

I have close to 50 jobs in a sequence job.
If I run the sequence and the job 26 aborts the next 24 jobs are getting stopped.

Is there any settings in the sequence job where If one job aborts leave that and go to the next job?
So that next time when I run the sequence after fixing the job only that particular job runs and rest of them will not run. This avoids other jobs waiting for this aborted job to run again.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 04, 2011 3:05 pm

You can achieve this with judicious use of triggers within the sequence for the first part. For the second part you would need to design your sequence to test each job's most recent exit status (via a routine activity perhaps), the exit status of the sequence itself, the dates associated therewith, and make the decision about whether to run each activity in the sequence.