topic Mail Notification for Long Run Jobs in Talend Studio

Mail Notification for Long Run Jobs

Anonymous — Fri, 13 Oct 2017 09:28:29 GMT

Hi Guys

Can you please guide me how to send a mail notification if job runs more than one hour in studio.

How can we capture time continuously when job runs.

Thanks

Deepthi

Re: Mail Notification for Long Run Jobs

Anonymous — Fri, 13 Oct 2017 09:35:59 GMT

This would be a nice thing that could be done with a Camel Route (ESB) and making use of the Talend MetaServlet. The reason for the Route would be that Routes are intended to be always running (so could monitor the status of the TAC), the metaservlet usage would allow you to periodically check the status of all of the jobs. If you have the TAC and use ESB, I would advocate trying this out (I may do in the future). What do you have to play with?

Re: Mail Notification for Long Run Jobs

Anonymous — Fri, 13 Oct 2017 09:47:36 GMT

Thanks

For your quick response

i am running few jobs in parallel in Talend DI

so want capture the time.Thanks

Understood your solution will try, as working with open studio i dont have TAC

can we have any method to achieve the same using TOS

Thanks

Deepthi

Re: Mail Notification for Long Run Jobs

Anonymous — Fri, 13 Oct 2017 10:05:44 GMT

This solution won't be as effective, but you could make use of the AMC functionality and have a Talend job scheduled to run every 5 mins to monitor the current status shown in the AMC tables. From that you could achieve this. If you are unsure about the AMC, I have written a bit about the AMC and how to set it up on my website. The first tutorial to look at is here (others are linked) https://www.rilhia.com/tutorials/talend-activity-monitoring-console-amc

Re: Mail Notification for Long Run Jobs

TR8 — Tue, 19 Jan 2021 14:00:30 GMT

Hi, why not to use taskexecutionhistory table?