topic Re: Execution Plan passing values between jobs in Talend Studio

Execution Plan passing values between jobs

_AnonymousUser — Sat, 16 Nov 2024 12:57:53 GMT

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.

Re: Execution Plan passing values between jobs

Anonymous — Fri, 22 Apr 2011 08:00:19 GMT

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

Re: Execution Plan passing values between jobs

_AnonymousUser — Fri, 22 Apr 2011 19:38:50 GMT

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.

Re: Execution Plan passing values between jobs

Anonymous — Sat, 23 Apr 2011 14:44:18 GMT

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