DSXchange

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

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

7.1 only!

Otherwise you get to roll your own checkpoints.

Oops! True.

Tony