DSXchange

Hi,
Prety simple one for all of you..........

If the sequence of job abort in some middle stage of the sequencer.Wat setting need to be done to restart the job from that point only after rectifying the error.

Thanks
Jayant

You can check the option 'Add checkpoints so sequence is restartable on failure'. This option can be found on the Job properties page of the job sequence.
The following is an excerpt from the DS designer guide.

You can enable or disable checkpointing at a project-widelevel, or for individual job sequences. If you have checkpointing enabled for a job, you can specify that individual components within a sequence are not checkpointed, forcing them to be re-executed whenever the sequence is restarted regardless of whether they were executed successfully
before.

Hi Jayant,

Search for Check point restart from this forum.
The option is available in job properties of the JobSequence.

-Kumar

What 7.x version of DataStage do you have? Ideally, the answer should be to check / enable the "Add checkpoints so sequence is restartable on failure" option. You may also set the "Automatically handle activities that fail" so that all you need to include are the "Ok" paths.

When the job aborts, its status should say "Aborted/Restartable". Simply run the job again to have it pick up where it left off.

Hi Jayant,
Using checkpoint option you can make the sequence to restart on failure.

regards
kcs

I guess that makes it unanimous.