Hi
In Talend Administration Center, there are "Talend Activity Monitoring Console (AMC)" and "Talend Log Server" .
I query the Admin DB to alert jobs, which are failed or hung.
SELECT talendjobname,
talendjobversion,
basicstatus,
detailedstatus,
serverjobstartdate,
serverjobenddate,
expectedtriggeringdate,
triggeredby
FROM Talend_Admin.taskexecutionhistory h
WHERE basicstatus != 'OK'
AND basicstatus != 'KILLED'
AND basicstatus != 'RUNNING'
AND serverjobenddate > Subdate(CURRENT_DATE, "+ context.ChecknDateBack+")
OR basicstatus = 'RUNNING'
AND serverjobstartdate <Subdate(CURRENT_DATE, INTERVAL 3 HOUR)
OR basicstatus = 'MISFIRED'
AND expectedtriggeringdate > Subdate(CURRENT_DATE, "+ context.ChecknDateBack+") ;
In Talend Cloud, I can check operations=>activity for error job graph. However,
1. I cannot setup access Admin DB for any alerts;
2. I don't know if tStatCatcher/tLogCatcher/tFlowMeterCatcher still work;
3. No AMC for the above stats.
How to add alerts for error jobs in Talend Cloud?
Thanks,
Bin
