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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Running multiple jobs one after the other on single RUN

Hi All,
I want to execute multiple jobs one after the other, for example i have Job_1 Job_2, Job_3 and each job has its own subjobs now i have to run Job_1, Job_2 and Job_3 one after the other on a single shot just like batch file.Please help me.
Thanks in advance.
Labels (2)
13 Replies
Anonymous
Not applicable

Hi,
You can use the tRunjob component linked by OnSubjobOK : From repositoy drag and drog your jobs in your MasterJob workspace.
Link all component by onSubjobOk link in the rigth order.
_AnonymousUser
Specialist III
Specialist III
Author

Hello I not understand the question like you.
I have the same issue I have lot of jobs which must run befor lot of others.
I need a think like a multi OnSubjobOK...
How can I do?
Thank 0683p000009MACn.png
Anonymous
Not applicable

Hello,
Use a OnSujobOK link between 2 tRunJob :
tRunJob_1 ( job_1 )
|
onSubjobOK
|
tRunJob_2 ( job_2 )
|
onSubjobOK
|
tRunJob_3 ( job_3 )
|
....
_AnonymousUser
Specialist III
Specialist III
Author

Serriously I can't do that. I have an enormus job which contain lots of subjob and lot of then must wait lot of others.
I can't change alaways all of the organisation to build my job...
It seem really simple if I can have a "multiOnSujobOK".
I anderstand both of your answer it's equivalent it's not good even if it's explain with a other way.
Anonymous
Not applicable

Try this Syphys
0683p000009MEg3.png
_AnonymousUser
Specialist III
Specialist III
Author

Hi,
I have a couple of jobs for which two different batch files have been created.
I run the batch file 1 and after completion, I trigger the next batch.
Is there a way to save the sum of the total time taken by both the jobs ?
Anonymous
Not applicable

Hi Ujesh,
Here is "Duration" schema in tStatCatcher which is time for the execution of a Job or a component.
For your job requirement, you can use Stat&Logs in project setting and enable "Use statistic(tStatCatcher)" to print the output  into a file or table.
Best regards
Sabrina
0683p000009MEic.png
_AnonymousUser
Specialist III
Specialist III
Author

Hi,
Thanks for the reply.
Could you provide an exhaustive solution to calculate the total duration ?
My current solution is like :
Batch 1 ----> Timeout ( varies to check reports and other stuff ---- > Batch 2
My requirement is to get the Total duration = ( Total Batch 1 completion time + Total Batch 2 completion time )
Is there a way to save only the duration ( in minutes ) of Batch 1 so as to use it at the end execution of Batch 2 to calculate the Total Duration time ?
Anonymous
Not applicable

Hi Ujesh,
Are you using Talend Subscription Version?
Best regards
Sabrina