How to continue the process

dsean · Post by **dsean** » Thu Jun 19, 2008 8:02 pm

HI All,
I am running a job in which it loads about 35million rows into an Oracle table. My job aborted in the middle after loading around 20 million rows.. I wonder is there any chance that i can start the job from the point where it stopped? or do I need to manually delete the rows from the table and rerun the job?

Job Design...

Seqfile --> Transformer lookup --> Oracle table

Thanks in advance
Sean

chulett · Post by **chulett** » Thu Jun 19, 2008 8:19 pm

Add a job parameter to indicate the number of records to skip and a constraint to skip them until @INROWNUM is greater than that value.

dsean · Post by **dsean** » Mon Jun 23, 2008 10:35 am

Thanks for the reply chulett.. I am marking this topic as resolved..

Sean

chulett · Post by **chulett** » Mon Jun 23, 2008 11:12 am

There's a button you need to press for that.