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.
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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.