Job Sequences

[cosec]

I am creating a job sequence to execute five jobs(with Parent/child relationships)...If one of them fails I need to roll back all the changes and rerun the sequence. How is this possible ?

Is there a way to not commit the jobs until the last one is completed successfully.


Thanks

[ray.wurlod]

Welcome aboard. :D

You need to design what you've just described. The easiest way is for all jobs to load a staging area, rather than the final target. Then, only if all jobs complete successfully do you move the data from the staging area to the final target.

[chulett]

To answer the question as asked - no. Jobs are discrete transactions, once one completes, its work is either commited or rolled back.