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
