Page 1 of 1

How to continue the process

Posted: Thu Jun 19, 2008 8:02 pm
by dsean
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

Posted: Thu Jun 19, 2008 8:19 pm
by chulett
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.

Posted: Mon Jun 23, 2008 10:35 am
by dsean
Thanks for the reply chulett.. I am marking this topic as resolved..

Sean

Posted: Mon Jun 23, 2008 11:12 am
by chulett
There's a button you need to press for that. :wink: