Execution Plan passing values between jobs

One Star

Execution Plan passing values between jobs

I'm running TIS 4.1.2.53616
Is it possible to pass values between jobs of an Execution Plan?
I've tried creating an Execution Plan parameter, but the value being set in the first job does not seem to be passed the a subsequent job.
Community Manager

Re: Execution Plan passing values between jobs

Hi
I tested it on v4.1.2 and it works.
- Make sure all the job have the same context name, the parameter of plan should be the same name, for exmaple, both of the job A and job B has a context variable called 'myname', add a plan parameter called 'myname'.
- Don't forget to click on the 'override' button to reload the new value for all the context variables.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Execution Plan passing values between jobs

I have three 3 job process running onOK from one to the other. I need the value generated in job 1 to passed to job 3, and I was hoping to not have to modify job 2 to do it. I'll try modifying job 2 adding the context variable and see if that resolves the problem.
Thank you.
Community Manager

Re: Execution Plan passing values between jobs

Hi
I need the value generated in job 1 to passed to job 3,

The plan parameter do not work for this case, the value is defined on the fly, I suggest you to create one job for 3 different child jobs, for example:
tRunjob_1(call the job1)---main--tJavaRow
|
onsubjobok
|
tRunJob_2(call the job2)
|
onsubjobok
|
tRunJob_3(call the job3)
job1:
.....generate a value --->main---tBufferOutput
Assuming each job has a context variable called name,
on tRunJob, define the schema, add the same column as tBufferOutput.
on tJavaRow:
context.name=input_row.columnName;
On each tRunJob component, check the box 'transmit whole context'
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business