How to add alerts for error jobs in Talend Cloud?

Seven Stars

How to add alerts for error jobs in Talend Cloud?

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

 

Seven Stars

Re: How to add alerts for error jobs in Talend Cloud?

Can anyone help me on this?

Thanks,

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.