I have 3 jobs to update/insert the same table in the database. Job1, Job2, and Job3.
Here I want to do is Job1 ---on sub job ok--> Job2 ----on sub job ok---> Job3
| on error | on error | on error
rollback rollback Job2 and Job1 rollback Job3, Job2 and Job1
Please help me how to design the job to realize this...?
Thanks for your help!