Starting the JOB SEQUENCE from where it has failed

rkumar28 · Post by **rkumar28** » Fri May 21, 2004 8:21 am

Hi,
I am doing a load from flat file to Teradata Database. I am generating a surrogate key from the DataStage which is a Primary Key in the Table.
I have created 2 jobs in the Job Sequence that runs one after the other and the trigger is OK...Conditional. It is the last Job in the job sequence, that does the real loading into the Database. I schedule my job for nightly load.

Is there a way to automatically restart my last job in the Job sequence if it FAILS and start from where it has failed.

Thanks for your time and help
Raj

tonystark622 · Post by **tonystark622** » Fri May 21, 2004 9:21 am

Raj,

On a Job Sequencer job, view the Job Properties. Check the checkbox that says "Add checkpoints so sequence is restartable on failure" and you should be able to restart the job at the point at which it failed.

tony

chulett · Post by **chulett** » Fri May 21, 2004 9:25 am

7.1 only!

Otherwise you get to roll your own checkpoints.

tonystark622 · Post by **tonystark622** » Fri May 21, 2004 9:56 am

Oops! True.

Tony