How to set Notification on a task with paused Trigger

Five Stars

How to set Notification on a task with paused Trigger

Hi 

 

Is there a way to get notified if someone paused the trigger and forgot to resume it, there by causing the job to not run for couple of days?

 

Thanks in advance

R

Moderator

Re: How to set Notification on a task with paused Trigger

Hello,

You can query TAC database for the list of all active and paused triggers.

The paused and active(waiting) triggers can be queried from qrtz_trigger table. The column name is Trigger_state. However, in this table the trigger is linked to a job id, if you need the job name with the trigger status than you can join the table like below:
SELECT label,TRIGGER_STATE FROM Database_name.QRTZ_TRIGGERS INNER JOIN Database_name.talendtrigger ON Database_name.QRTZ_TRIGGERS.TRIGGER_NAME = Database_name.talendtrigger.id;

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

Re: How to set Notification on a task with paused Trigger

Hello,

 

we do not have this in TAC now. And we do not have plans to do it in TAC. But this is nice feature and I created new feature request to work on it in TMC: https://jira.talendforge.org/browse/TMC-14569

 

Thanks,

Yuri

Five Stars

Re: How to set Notification on a task with paused Trigger

@yshamin : Thank you for creating a new Feature Request !

Five Stars

Re: How to set Notification on a task with paused Trigger

@xdshi : Thanks Sabrina for the information. I did query the Trigger tables, but the data in there is different for the 2 Columns, so the join failed and getting 'data type conversion errors'. To test , I created a new Trigger in TAC for a task and that entry shows up with Trigger_name 9, while the ID is 11 in the TalendTrigger Table.

Looks like we have to clean-up the data in these tables. 

Capture_trigger Tables_926.JPG

Moderator

Re: How to set Notification on a task with paused Trigger

Hello,

Could you please clarify in which Talend version/edition you are? Additionally, you can also get Trigger status details of Execution plan using Metaservlet API.

 

To get the Triggers details you need to call "listTrigger" command:

----------------------------------------------------------
Command: listTrigger
----------------------------------------------------------
Description : List all trigger.
-taskId: if the taskId is not provided, it lists all the triggers; if it is provided, it lists all triggers related to the taskId
Requires authentication : true
Since : 5.6
Sample :
{
"actionName": "listTrigger",
"authPass": "admin",
"authUser": "admin@company.com",
"taskId": "1"
}

You get the taskId (planId) of the execution plan from "listExecutionPlans".

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: How to set Notification on a task with paused Trigger

Sabrina - We are using Talend v6.1

Moderator

Re: How to set Notification on a task with paused Trigger

Hello,

This feature has been achieved since v 5.6. You can use it on Talend v6.1. Could you please try to get Trigger status details of Execution plan using Metaservlet API?

Feel free to let us know if it doen't work for you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

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

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download