How can u restart a job??

[RakshaPai]

Hi all,

Can anyone please tell me how can i restart my job in case of failure/abend and rollback any changes it has made to the target database ??

i need to do the failure handling for the job and i cant figure out where to start...

Thanks!

[ray.wurlod]

I imagine U (a poster on this forum) can restart a job the same way anyone else can.

The real issue in your question is how to undo anything that's already been committed. This must be designed in. If every record added to the target carries a "run ID" or timestamp, then it's easy to delete these items. Otherwise your job design has to keep track of what's been successfully committed and incorporate some "restart from there" logic.