How to restart ETL job automatically when a job fails

Mallayagari · Post by **Mallayagari** » Tue Apr 20, 2004 3:20 am

How can I provide restart instructions in the ETL program when a job/step fails. Can it be done with datastage?? if not how can it be done.
TIA
Macks

roy · Post by **roy** » Tue Apr 20, 2004 4:30 am

Hi,
to reset a job you can choose :
1. run the job in reset mode; via dsrunjob or dsjob command line.
2. if you use basic code you can issue a DSPrepareJob(<jobhandle>) once you attached the job and before you run it.
3. if you use job sequences to run other jobs simply use the reset if required then run option in the JobActivity stage.

(just noticed this is a parallel question, not sure if works the same as server jobs

)

IHTH,

chulett · Post by **chulett** » Tue Apr 20, 2004 5:55 am

One of the new features in version 7.1 (not 7.0.1) of DataStage is some sort of automatic Checkpoint / Restart capability they have added to Sequence jobs. From what I understand (I haven't seen it yet) this would help get a series of jobs restarted from the correct job... getting the restarting job to "pick up where it left off" is a whole 'nuther ball game.

Much like Roy, I have no idea if any of this applies to PX jobs.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 20, 2004 4:36 pm

No job, whether server, parallel or mainframe, has the ability to restart itself.
Restart capability must be implemented in a job control routine of some kind (whether build from scratch, from a Batch or from a job sequence, or using an external scripting language).