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
Job Sequences
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.