topic Re: Restartability in Talend Studio

Restartability

shalinim1 — Sat, 16 Nov 2024 01:12:37 GMT

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

Re: Restartability

vikramk — Fri, 30 Oct 2020 07:37:59 GMT

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.

Re: Restartability

shalinim1 — Fri, 30 Oct 2020 14:03:15 GMT

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

Re: Restartability

vikramk — Fri, 30 Oct 2020 17:21:06 GMT

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.

Re: Restartability

shalinim1 — Sat, 31 Oct 2020 15:49:23 GMT

Will check on it and let u know @Vikram Kumar