how to run the abort job from the last record

deesh · Post by **deesh** » Tue Dec 11, 2012 5:54 am

Hi,

Please any one give me a solution, if the job fails in 2022 record, after rectifying the issue how to run the job from 2013 records onwards.

Generally i enable the checkpoints, truncate the entire data and re-run the job, but the checkpoint for the job, what about the records.

abhijain · Post by **abhijain** » Tue Dec 11, 2012 6:50 am

You may do it by setting the commit interval to 1, but that would compromise the performance.

chulett · Post by **chulett** » Tue Dec 11, 2012 7:36 am

Simply setting the commit interval to 1 doesn't "do it" - it just may make it easier to know where to restart. And how you restart is up to you (you need to build it in) and is not a short discussion. High level, you need a mechanism to track where you left off and a matching process to skip everything up to that point before you start passing rows to the target. Multiple ways to accomplish that and it can depend on your source / target and the nature of the data you are processing.