DATASTAGE SEQUENCER

jayantthakore · Post by **jayantthakore** » Wed Feb 01, 2006 11:22 pm

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

bakul · Post by **bakul** » Wed Feb 01, 2006 11:48 pm

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.

kumar_s · Post by **kumar_s** » Wed Feb 01, 2006 11:48 pm

Hi Jayant,

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

-Kumar

chulett · Post by **chulett** » Wed Feb 01, 2006 11:50 pm

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.

kcshankar · Post by **kcshankar** » Wed Feb 01, 2006 11:51 pm

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

regards
kcs

chulett · Post by **chulett** » Wed Feb 01, 2006 11:52 pm

I guess that makes it unanimous.