Four Stars

Job design with rollback/savepoint

Hello,

 

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