Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can you run jobs in parallel using tRunJob set to dynamic?

Hi
I have now got a job set up to dynamically run other jobs passed in from a database table. I.e. I can decide which say 30 jobs to run out of say 50 jobs. But I want the jobs to run in parallel for performance reasons. At the moment the tRunJob waits for each job to finish before starting the next. Is there any way around this? I have the main job (the one with the tRunJob component in it) set to multi threaded and have tried checking and un checking the "die on child error" option on the tRunJob. If what I am trying to do will not work with tRunJob is there any other way to do it?
This is the structure of the main job
tOracleInput (returns the list of jobs to run)
|
tFlowToIterate (sets a key to the job name)
|
tRunJob (Set to dynamic with the Context job field set to the key set above)
All of the jobs are in the Job list
Many thanks in advance
Dave
Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hello david,
i have created something similar to what you are trying to do.
running jobs in parallel - but instead of calling them from a tRunJob, i have set the 'child' job as a web-service and deployed on multiple hosts. passing parameter on the web-services and checking for their results in a DB table.
does that help?
Nicolas
Anonymous
Not applicable
Author

Hi Nicolas
Many thanks for the response. I have not looked at the web service approach so I will take a look at this. We currently deploy all of our jobs as Java executables on Unix for scheduling with an enterprise scheduling tool, so the use of web services may be a problem.
I also meant to add to my post. Is there a difference between how tRunJob is implemented in TOS 4.2 and TIS 4.2? I am using TOS 4.2 while waiting for the TIS 4.2 install. I notice that there is no tparrallisze component in TOS 4.2.
Dave
Anonymous
Not applicable
Author

there are differences between the TIS and TOS version, and rightly so - since you are paying for the greater options on TIS.
see here:
http://www.talend.com/products-data-integration/matrix.php
Anonymous
Not applicable
Author

daveseavista, With TIS, you can parallelize your iterate connectors and this will probably work with the dynamic tRunJob-- but I haven't tried it so please let us know how it works out.
ravi999
Contributor III
Contributor III

Hi Nicolas, 

 

Could you please let us know how to set the child job as a web service or post a pic of the job if possible or any blog ? I have googled and couldn't find any documentation. 

 

Thanks in advance