sequence restart and job reset

[harryhome]

I have 3 jobs J1, J2, J3 in seq1 as J1--> J2 --> J3

"Reset if required then run" is checked in each of 3 job activites

"Add checkpoint so sequence is restartable on failure" is checked at Seq1 level

In first run if J1 is successful and J2 is aborted then Seq1 is aborted.

I will place missing source file for J2 in place then

In Second run I need Seq1 to invoke J2 and then J3, But now J1 J2 J3 all three jobs run.

Please guide

[kris007]

"Add checkpoint so sequence is restartable on failure" is checked at Seq1 level
In first run if J1 is successful and J2 is aborted then Seq1 is aborted.
Please guide

Are you sure Seq 1 is in Aborted state and not in Aborted/Restartable or Finished state.

However, you will need to check "Automatically handle job runs that fail" property within the Job properties of the Job sequence. For Seq1 to start from the point it failed, make sure the Seq1 is in Aborted/Restartable after J1 fails and also make sure you did not check the "Do not check point run" with in the Job Activity stage.

[harryhome]

Thanks.

In Job activity I have selected "Reset if required then run" so that I need not to compile the job (in case no change in design). Is that correct?

[kris007]

(in case no change in design). Is that correct?

Is this after you have made/verified the changes I had suggested earlier? The answer depends on what you did after my post.

[harryhome]

Yes I checked "Automatically handle job runs that fail"

Also I have "Add checkpoint so sequence is restartable on failure"

Both at seq1 level.

Then I have "Reset if required then run" selected in each job activity

[kris007]

You did not yet answer about the "Do not checkpoint run" option within the Job Activity stage. Apart from that, its time to do your test run and see how it goes and make some adjustments accordingly.

[harryhome]

"Do not checkpoint run" option is not checked.

[kris007]

In that case you should see the desired results.