[resolved] Modify CRON trigger out of TAC ?

Highlighted
One Star

[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


Accepted Solutions
One Star

Re: [resolved] Modify CRON trigger out of TAC ?

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


All Replies
One Star

Re: [resolved] Modify CRON trigger out of TAC ?

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

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog