Restartability

[shalinim1]

Hi,

How can I implement restartability of the job without using tcheckpoint components? And want to store the details in a file or a db table

[vikramk]

Hi @Shalini M​ ,

You have two ways to achieve this-

1. By restarting the job from point of failure using "tcheckpoint" component.

2.By implementing roll over concept in job on failure of database loading, this will revoke the changes made by job in the current execution before its get failed. You have database rollover components available in talend.

You can implement this in your job based on component error .

Please let me know if it helps.

[shalinim1]

Thanks for your response @Vikram Kumar​. Could you please help me with the second type? Could you elaborate the steps?

[vikramk]

Hi @Shalini M​ ,

Please go through this below link,

https://help.talend.com/reader/tXRG~nTonRYUwbOJscDgxw/A~tGKVMHcRVcvlopgJGXSw

you can implement like this

-tdbconnection->tdbinput->tdboutput->on componenterror->tdbrollback

On failure of loading to db connection if you are using tdbrollback component with on component error, the no. of rows lloaded to db untill failure will be rolled back to its original state before the job execution.

Please mark it as solution if it helps you.

[shalinim1]

Will check on it and let u know @Vikram Kumar​ ​