HOW TO RESTART THE JOB

[Sathish321]

Hi
How can I restart the job, if job get aborted after loding some data into DB.
I need to start the job from where the last record loaded.

Thanks
Sathish

[Yuan_Edward]

Well, it depends on your requirement and preference.

Some of my options will be:
1. truncate and reload the whole
2. Replace/overwrite
3. Take the whole load as a single transaction
4. Do a lookup and only load the rest of records when reloading
5. More...

Hi
How can I restart the job, if job get aborted after loding some data into DB.
I need to start the job from where the last record loaded.

Thanks
Sathish

[kumar_s]

Job by itself doesn't have check point restart on record wise, but you can built you own logic.
Always do a select Max(key) from your target and based on the result, you can select the source. But since there is not details given on how and what is the source extract, let me assume that, it will have unique key for each run.
Make sure you have record wise commit.
To get more clear details, you need to need to explain about the source data and load logic.

[DSguru2B]

If your data volume is low, set the transaction size to 0. This way the data will be committed only after successful completion of the job.
Is this a server job or a px job?