You can translate the question and the replies:

Rollback Job Scheduler

Hi Team, Assume we have some 5 jobs and all have been set to job dependency of each other. Job 1,2,3,4 are dependency of Job 5. In Job 1 and Job 2 , I do exporting the data to JDBC (SQL server table) . Job 3 is just the extraction and Job 4 is again exporting data to JDBC (SQL Server table) and Job 5 is just to update the status of the job, which is available on JDBC (SQL Server table). Incase if any of the job failed , I would like to revert whatever happened and bringing back to the original stage. There are 3 options 1.Never Rollback 2. Rollback for all transaction fails 3. Rollback any transaction fails In my case I'm going for option 3, because if any failure happens I would like to stop and revert. Let us assume Job 3 failed and whatever data being inserted from Job 1 & 2 should revert. Also incase of failure after I fix the issue, I would like to re-start where it got stopped. When I try for option "Start with state" only the particular job started and completed but the other dependency jobs are not executing Is there a way we can achieve this. Thanks in advance
user
28-07-2022 11:22:26 -0400

1 Answer

Hello, To solve this problem it would require an examination of how your jobs are configured. If you would like assistance in troubleshooting this further, please open a new support case at [Denodo Support Site](https://support.denodo.com/) so that the support team can review the issue in detail to assist you. Hope this helps!
Denodo Team
29-07-2022 14:28:20 -0400
You must sign in to add an answer. If you do not have an account, you can register here