How to get execution end of a job

[Anonymous]

Hi,

How can I get the execution end time of my job and put it in the column called "executionEnd".

Is there any possible way I can write it in the expression builder of the column. The format is dd-MM-yyyy HH:mm:ss Thanks.

[akumar2301]

if you are running this in your current job and it is your last component , you could simply use new Date() expression.

[joearun4u · Accepted solution]

Hi Shaneacara,

You can calculate the execution stop time by introducing log components tChronometerStart and tChronometerStop before and after of your execution. From the log result , you can pass the execution end time to your column..

Thanks,

Joe

Give kudos if you found this solution is useful.

[Anonymous]

Hi,

    If you want to do analysis of the job execution time, the best option is to use AMC component of Talend.

    I would suggest you to go through below article to get basics of AMC.

https://www.talend.com/resources/data-integration-amc-studio-features/

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

How can I get the value of the tChronometerStop and put it in my column?

[Anonymous]

Hi,

    Could you please share job screenshots so that we will get more idea about your use case?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[joearun4u]

Hi Shaneacara,

Another simple way is, you can use built-in function TalendDate.getCurrentDate() to get the current date in tJava at the beginning and end of job and store it as a global variable. In tmap you can use the global variable anytime to populate the value.

Eg., use the below code in tJava to get start time and end time

globalMap.put("startExecutiontime", TalendDate.getCurrentDate());

globalMap.put("endExecutiontime", TalendDate.getCurrentDate());

Regards,

Joe

Give Kudos if you found this tip is useful.