How to set Notification on a task with paused Trigger

[sr11]

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

[Anonymous]

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

[Anonymous]

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

[sr11]

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

[sr11]

@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. 

. 

[Anonymous]

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

[sr11]

Sabrina - We are using Talend v6.1

[Anonymous]

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