Hi All
In a seq 1, runs a job1, if job1 executed successfully, it will execute seq 2,runs job2, if job2 executed successfully, it will execute seq 3,runs job3, if seq 3 is warning,i need rollback the action took in job2. In job2 i am updating a flatfile, i want to rollback the update.
Thanks in Advance,
T Sankar
achieving the seq
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If job 2 commits, that's that - it's committed.
You would need to redesign to put job3 into seq2, so that its start can be conditional on success of job2 AND somehow you must record the updates that occurred (were committed) in job2 so that they can be undone. They can't be rolled back unless you take control of transaction handling (establishing an outer transaction), possibly through BCI functions in Routines, which is really difficult given that different stages can, and different jobs and sequences do, run in separate processes.
You would need to redesign to put job3 into seq2, so that its start can be conditional on success of job2 AND somehow you must record the updates that occurred (were committed) in job2 so that they can be undone. They can't be rolled back unless you take control of transaction handling (establishing an outer transaction), possibly through BCI functions in Routines, which is really difficult given that different stages can, and different jobs and sequences do, run in separate processes.