topic Re: job recursive calls in Talend Studio

job recursive calls

_AnonymousUser — Sat, 16 Nov 2024 14:00:42 GMT

Hello,
How can I call recursively a job (TOS 3.0.4) ?
The component tRunJob does not allow calling the job in which the component is used.
I want to do something like :

MyRecursiveJob =
+subJob1
|
|
OnSubJobOK
|
|
+tDBInput ---If (tMSSqlInput_NB_LINE >0) ---> tRunJob_1(MyRecursiveJob)

Is there a simple way to do that ?

Thanks

Re: job recursive calls

Anonymous — Wed, 01 Apr 2009 15:40:56 GMT

Hello,

yes you can :

1) Create a job that call your "MyRecursiveJob"
2) Call this job from MyRecursiveJob !

But isn't the better way. Are you sure to need to use recursivity ? be aware with memory and exit condition.

Re: job recursive calls

Anonymous — Thu, 25 Jun 2009 14:57:28 GMT

Hi,
I would like to use recursive calls too, to be able use a hierarchy table with this kind of structure :
hierarchy_table(id_parent number, id_child number)
like the nodes of a tree...
I've been looking several ways with the loop component, but i did not find any solution.
I'm not asking you to do my job, but do you have any idea of how to make easy and not so heavy for the memory, or do i have to use job calls like you explained before?
Just for information, i'm using TOS 3.0.5 with Java and a MySQL 5 db,
Thanks and have a nice day...

Re: job recursive calls

Anonymous — Mon, 29 Jun 2009 22:11:36 GMT

Hi,
first: did anyone tried Menuet solution? I think this is not possible because different variables are defined as static. This will lead in many problems. This is, from my point of views, a big design issue. So you need to transform your recursive call to an loop. This should (theoretical) always be possible.
If you give some more information about your job, we could try to help you out
Bye
Volker

Re: job recursive calls

Anonymous — Fri, 21 Aug 2009 15:38:33 GMT

Sorry I forgot to give you some feedback.
Here it is :
I tried emenuet's solution but it did not work (can't remember the error but when I cliked on the run button I got an error message before the process really started).
Anyway you were right, it was possible to avoid this recursive call with a loop and a global variable.
Thanks
Fred

Re: job recursive calls

_AnonymousUser — Tue, 17 May 2016 14:28:54 GMT

Hello,
Can anybody post the answer here?
MyRecursiveJob =
+subJob1
|
|
OnSubJobOK
|
|
+tDBInput ---If (tMSSqlInput_NB_LINE >0) ---> tRunJob_1(MyRecursiveJob)

I have the same problem, and I do not know how to create and call a recursive job.
Thanks in advance.

Re: job recursive calls

Anonymous — Tue, 17 May 2016 14:48:35 GMT

I think the answer to this question is to use tLoop.
tLoop(Iterate)->tRunJob(OnSubJobOK)->SubJob
Where SubJob is your logic to determine if the loop should end.
And maybe adding a Thread.sleep() before the next iteration of the loop may be useful.
This is iteration not recursion.

Re: job recursive calls

_AnonymousUser — Wed, 18 May 2016 15:29:54 GMT

Thank you tal00000 !

It is helpful, I use an iteration and it works.

tLoop--->iterate--->myChildJob

I retrieve the value returned by myChildJob and check it in the tLoop condition (while).

Regards,