Automatically handle activities that fail

chulett · Post by **chulett** » Sat Jul 14, 2007 12:54 pm

With no details on the actual design of your Sequence job, all you can get is a generic answer, which is the latter - 'other jobs finish first then the sequence will go in Aborted state'.

tsamui · Post by **tsamui** » Sat Jul 14, 2007 2:08 pm

In details I have five parallel jobs. Each job copy data from data warehouse to one another database. I create a sequence and create five jobs activity using these parallel jobs in this sequence and there is no connection (dependency) between them. If I run this sequence and one job activity abort, the sequence aborts immediately?

ray.wurlod · Post by **ray.wurlod** » Sat Jul 14, 2007 2:20 pm

What setting do you use for "Automatically handle activities that fail"?

Have you considered including an Exception Handler?

What precisely do you wish to happen if one of the jobs under control aborts? The Exception Handler may need to lead to a Terminator.

chulett · Post by **chulett** » Sat Jul 14, 2007 5:07 pm

tsamui wrote:If I run this sequence and one job activity abort, the sequence aborts immediately?

No.