Restartable sequence jobs

ketanshah123 · Post by **ketanshah123** » Wed Dec 10, 2008 12:22 am

Hi All ,

We have created certain server jobs for interface say ABC.Those jobs are for extraction, transformation, load. Then we have created certain sequence jobs for extraction, transformation, load where all the severs jobs are added . These seuence jobs are then added in master sequence job of our DataWarehouse.

Currently if any jobs of interface ABC fails we are not able to restart the Interface/seuence jobs.

My querry is we need to make changes to existing sequnece jobs (may be create a new sequnce job) so that they can be restartable.

So what chnages do I need to do to make these sequnce job restartable ?

Thanx in advance ...

ray.wurlod · Post by **ray.wurlod** » Wed Dec 10, 2008 3:53 am

Check the "restartable" check box in the sequence compiler options (in job properties) and re-compile the sequence. Are you comfortable with what that will and won't give you?

ketanshah123 · Post by **ketanshah123** » Wed Dec 10, 2008 8:18 am

thanx for your suggestion. I am aware of wht it will also gone thru DataStage PDF anf got clear understanding of it.

Can you please explain relation between restartable sequence job and execution action option RUN and Reset if required, run

chulett · Post by **chulett** » Wed Dec 10, 2008 9:03 am

Reset if required is needed to rerun an aborted job, a key need when building restartable Sequence jobs. If you simply say "Run" and the job is Aborted, the attempt to rerun the job will fail.

ketanshah123 · Post by **ketanshah123** » Thu Dec 11, 2008 1:40 am

chulett wrote:Reset if required is needed to rerun an aborted job, a key need when building restartable Sequence jobs. If you simply say "Run" and the job is Aborted, the attempt to rerun the job will fail. ...

Thank you very much ... Now I am able to create a restartable sequence job n its working fine