DSXchange

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

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.

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