Job Sequence Fails to Restart at Point of Failure

[kris007]

Job Activity #1
Check Pointed

Job Activity #2
Check Pointed

Job Activity #3
Check Pointed
Seyed

Are you selecting "Do not checkpoint run" option within the Job Activity Stage? If so, uncheck it.

[kris007]

From what you are saying, the status in the end was not 'Aborted'. How do I go about fixing the job sequence to have an 'Aborted' status when a job in the sequence aborts?
Seyed

You will need to select "Automatically Handle activities that fail" with in the Job Properties of the Job sequence or Use an Exception handler in the job sequencer with its output link to the Terminator Stage or Both.

[chulett]

The Sequence must abort for the checkpointing to work and you'll find it in an Aborted/Restartable status in that case. You can leverage the Terminator stage for this, amongst other things.

[Seyed]

Job Activity #1
Check Pointed

Job Activity #2
Check Pointed

Job Activity #3
Check Pointed
Seyed

Are you selecting "Do not checkpoint run" option within the Job Activity Stage? If so, uncheck it.

Kris,
I just double checked and verified that for all three activities, the 'Do not checkpoint run' check boxes were unchecked.

Thank you,

Seyed

[kris007]

What about the other suggestions in my later post and from Craig's post?

[Seyed]

From what you are saying, the status in the end was not 'Aborted'. How do I go about fixing the job sequence to have an 'Aborted' status when a job in the sequence aborts?
Seyed

You will need to select "Automatically Handle activities that fail" with in the Job Properties of the Job sequence or Use an Exception handler in the job sequencer with its output link to the Terminator Stage or Both.

Kris,
Thank you for the information. I made this change and recompiled the job sequence and ran it again, it didn't make any difference. Reading your posts and also Craig's, I realized that this job sequence doesn't have a 'Terminator Activity'. How important is it to have a 'Terminator Activity'?

Thanks again,

Seyed

[chulett]

What's important is that it aborts and the Terminator is one way to make that happen.