Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Modify CRON trigger out of TAC ?

Hello,

I use a CRON Trigger in TAC in order to schedule my job.
I try to find a way to update my trigger without using TAC (to automate a modification for example).

I found the table in admin database who store the triggers : talendtrigger
If I update the trigger in the table, when i check the trigger in TAC, I can see the modification. But the trigger keeps his old behavior : the modification is not really applied.
I guess when we update a trigger in TAC, the modification is done in database AND a process is launch in order to apply the modification in the system.

How can I find the command to execute to apply the modifications done manually on the table talendtrigger? (Im on CentOS)

Thanks

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello,
The support gave me the solution to do that using MetaServlet :

Example :


sh MetaServletCaller.sh --tac-url=http://localhost:8080/org.talend.administrator --json-params='{"actionName": "updateTrigger",
    "authPass": "admin",
    "authUser": "admin@company.com",
    "daysOfMonth": "10",
    "description": "This is a cron trigger",
    "hours": "5,10",
    "id": 1,
    "label": "CronTrigger1",
    "minutes": "1,10",
    "months": "*",
    "pauseOnError": true,
    "timezoneOption": "JOBSERVER_TIMEZONE",
    "years": "2016"
  }'

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Hello,
The support gave me the solution to do that using MetaServlet :

Example :


sh MetaServletCaller.sh --tac-url=http://localhost:8080/org.talend.administrator --json-params='{"actionName": "updateTrigger",
    "authPass": "admin",
    "authUser": "admin@company.com",
    "daysOfMonth": "10",
    "description": "This is a cron trigger",
    "hours": "5,10",
    "id": 1,
    "label": "CronTrigger1",
    "minutes": "1,10",
    "months": "*",
    "pauseOnError": true,
    "timezoneOption": "JOBSERVER_TIMEZONE",
    "years": "2016"
  }'