You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
here's my master job
job1->job2
job1
toracleinput-tmap- (insert) toraclebulkoutputexec
(update) toraclebulkoutputexec
job2
toracleinput-tmap- (insert) toraclebulkoutputexec
(update) toraclebulkoutputexec
say job2 update failed. I just want to run the master job but just the update in job2(since it failed) and not the insert in JOB2 nor the inserts and updates from job1 since they were all successful.
I know we can deactivate other jobs but that would be a manual way. I can't be doing this when we move to prod where everything runs from TAC.
Is there a better way to do this? how to rerun the master job from failure point?
Hi,
I think it can be done using a transaction with commit and rollback component.
With version of TIS you're able to put a recovery error "mark" and manage via TAC (administration Center).
regards
laurent
Offline

You could create a file on successful completion of each step. Then as part of your job design check to see if the file exists before running the step. Delete all the files on successful completion of all steps.
Last edited by janhess (2012-07-31 15:53:30)
Offline
Pages: 1