Four Stars

Dependent Execution plan trigger

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
5 REPLIES
Community Manager

Re: Dependent Execution plan trigger

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Dependent Execution plan trigger

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
Community Manager

Re: Dependent Execution plan trigger

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Dependent Execution plan trigger

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
Community Manager

Re: Dependent Execution plan trigger

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
----------------------------------------------------------
Talend | Data Agility for Modern Business