How to add alerts for error jobs in Talend Cloud?

Highlighted
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,

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Modern Data Engineering in the Cloud

Learn about modern data engineering in the Cloud

Watch Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog

Talend API Services Publish to Talend Cloud

Learn how to publish your API Services to Talend Cloud

Watch Now