topic Re: Dependent Execution plan trigger in Talend Studio

Dependent Execution plan trigger

Anonymous — Thu, 15 Dec 2016 11:28:05 GMT

Hello All,
We have single execution plan (which has 30 Jobs) which is working fine when we do cron triggering or manually run.
Now our requirement it to trigger this execution only when other process is completed(workflow Process). We have recommended two option :
1) workflow Process will insert one record in of the table after completion of process: In this case from talend how we can check the record is inserted and once it there in table our execution plan should trigger?
2) Workflow process will place file on talend server : In this case how we can check file is there on talend server and trigger the execution plan?
We are going to prefer first option.
Request all to help me on above topic.
Thanks in Advance!!!!!!!
Regards,
Vivek

Re: Dependent Execution plan trigger

Anonymous — Wed, 21 Dec 2016 04:34:55 GMT

Hi
I would recommend option 1, there is a global variable that counts the total number of inserted records, eg:
((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED"))
You can check this value if it equals 0, if so, fires a tDie component in the job to make the job fails.
Create two execution plan, one for workflow process job, another for original job, and schedule the execution plans with OK button.
original job plan--OK-->workflow process job plan
Regards
Shong

Re: Dependent Execution plan trigger

Anonymous — Mon, 23 Jan 2017 05:58:07 GMT

Hello,
original job plan--OK-->workflow process job plan
As per my understanding we can define dependency in tasks which are added on TAC server in execution plan, How can we define dependency in Execution plan on TAC server?
Just consider we have two execution plan, Plan1 & Plan2 , I want to execute the plan2 only when plan1 execute succesfully.
Plan1 ----> OK ---Plan2
I tired to find same in execution plan page and no success.

Regards,
Vivek

Re: Dependent Execution plan trigger

Anonymous — Tue, 24 Jan 2017 03:35:24 GMT

Hi
I think my previous post mislead you. In fact, the plan is scheduled based on the deployed tasks, you just add a plan like:
task1( original job)-->OK-->task2( workflow process job)

Regards
Shong

Re: Dependent Execution plan trigger

Anonymous — Thu, 23 Mar 2017 04:53:08 GMT

Hi,
Thanks for your suggestion!
Here I am intersted to know is there is any way we can define dependency in execution plan?
As per above comments we can define dependency in tasks which we have added in TAC server and we are currently doing it in our project.
Here we have two seperate execution plans(each plan has around 30 jobs) and we dont want to merge those two plans with single plan to achive the required dependency. As one exceuion plan say plan1 schedeuled only once in a week i.e on Monday and another say Plan2 schduled on daily. So we want on every monday Plan2 should execute only when Plan1 execute successfully.
Please let me know if needed more information.
Regards,
Vivek

Re: Dependent Execution plan trigger

Anonymous — Fri, 24 Mar 2017 10:17:34 GMT

As one exceuion plan say plan1 schedeuled only once in a week i.e on Monday and another say Plan2 schduled on daily. So we want on every monday Plan2 should execute only when Plan1 execute successfully.
Please let me know if needed more information.

Hi
It is impossible to do it, there are three types trigger for execution plan based on execution result: OnOK, OnError, afterAll. If plan1 is not scheduled to run, plan2 will not run either.
Regards
Shong

Re: Dependent Execution plan trigger

Anonymous — Sat, 25 Jan 2020 16:12:15 GMT

Hi,

I want to achieve the second option. I have a task which takes file from the job server path and places the file to S3. I tried running this task through file trigger and the task executed when the file was present on path and put the file to S3. I created an execution plan for the task but when i tried file trigger at execution plan level, the Execution plan is not triggering. I checked whether the execution plan is working fine or not by manually triggering the EP. The EP runs fine and places the file present at path to S3. Please help me understand what could be the issue with the file trigger for the execution plan?

Re: Dependent Execution plan trigger

Anonymous — Sun, 26 Jan 2020 06:53:14 GMT

Can someone help me with the above issue?