You are not logged in.

#1 2012-07-31 13:46:47

recrey3402
Guest

recovering from error

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?

#2 2012-07-31 14:01:24

kzone
Member
1279 posts

Re: recovering from error

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


Manage your data before data manages You !!!

Offline

#3 2012-07-31 14:52:57

janhess
Member
1295 posts

Re: recovering from error

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 14:53:30)

Offline

Board footer