Running multiple jobs one after the other on single RUN

One Star

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.
Employee

Re: Running multiple jobs one after the other on single RUN

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.
One Star

Re: Running multiple jobs one after the other on single RUN

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 Smiley Happy
Employee

Re: Running multiple jobs one after the other on single RUN

Hello,
Use a OnSujobOK link between 2 tRunJob :
tRunJob_1 ( job_1 )
|
onSubjobOK
|
tRunJob_2 ( job_2 )
|
onSubjobOK
|
tRunJob_3 ( job_3 )
|
....
One Star

Re: Running multiple jobs one after the other on single RUN

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.
One Star

Re: Running multiple jobs one after the other on single RUN

Try this Syphys
One Star

Re: Running multiple jobs one after the other on single RUN

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 ?
Moderator

Re: Running multiple jobs one after the other on single RUN

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Running multiple jobs one after the other on single RUN

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 ?
Moderator

Re: Running multiple jobs one after the other on single RUN

Hi Ujesh,
Are you using Talend Subscription Version?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Running multiple jobs one after the other on single RUN

Hi,
I am currently using Talend DI free version
Moderator

Re: Running multiple jobs one after the other on single RUN

Hi,
Talend provides real time statistics in Talend Subsciption product.
The real-time statistics information consists of the execution time of each task and its corresponding Job, the number of rows processed in each data flow and the time taken to process them, and the number of rows processed per second.
Could you please check this document about:TalendHelpCenter:Collecting the Job execution statistics to see if it is satisfying your needs?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Running multiple jobs one after the other on single RUN

Hi ,
What if jobs are interdependent ? I mean output of one job will be passed as input to another . Can dragging and connecting two jobs will help? If not What should be done in such scenario
Thanks,
Mohana Bhunekar
Moderator

Re: Running multiple jobs one after the other on single RUN

Hi Mohana Bhunekar,
Could you please set an example for your use case?
Screenshots will be preferred.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.