Four Stars

Job design with rollback/savepoint



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!



  • Data Integration