synchronize jobs

Highlighted
One Star

synchronize jobs

Hi,
I'd like synchronize two jobs before ending the last. How can I do that?
I've two same jobs which are linked with On_component_OK on a tRunJob component.
I'd like execute tRunJob after the two first. Is it possible to have an logical AND before a job or subjob?
Thanks for your answer

Re: synchronize jobs

look into the tParallelize component, it can do what you want.
One Star

Re: synchronize jobs

Hi,
Thanks JohnGarrettMartin. I use TOS 3.0.4 and tParallelize is a TIS component, isn't it? Can I use it with TOS and how?
One Star

Re: synchronize jobs

I have a question. Consider there are 3 jobs each job loads three different MS-SQL tables. I want to do the commit for all the three tables only after all three jobs have been completed successfully. Is it possible in Talend?
Community Manager

Re: synchronize jobs

Hello
I have a question. Consider there are 3 jobs each job loads three different MS-SQL tables. I want to do the commit for all the three tables only after all three jobs have been completed successfully. Is it possible in Talend?

Yes, it is possible. Move the 3 subjobs into a child job. In the father job, using a tRunJob to run the child job, both father job and child job share the same connection, if the child job runs fine, commit the records, otherwise, rollback all the records. See my screenshots
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads