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: 
abhi90
Creator II
Creator II

Trigger Success mail only when 3 Child Jobs completes

Hi All,

 

Hope everyone is doing fine here with Talend Learning 0683p000009MACn.png

 

I have a scenario where I have to trigger my SuccessMail only when 3 of the Child Jobs will be completed. Now after tparallelize------------>(Parallel) 3 Child Jobs Connected--------->Synchronize(SuccessMail). problem is once each job is getting completed SuccessMail is triggering. And I want all 3 to be completed and then only Successmail should trigger. I have tried taking it in tPostJob but there problem is if any of those 3 Job fails still in postjob SuccessMail is triggering. Can anyone please help on how to handle this scenario.

 

@rhall@TRF@vapukov@vboppudi@manodwhb 

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

 

     You are currently adding the subjobs before tparallelize component. This is the reason why three OnSubjobOK are present before your tparallelize component and are executing before paralelize component. If you observe my previous post, I have created parallel operations for child jobs after tparallelize component.

 

      If you are connecting a job correctly, the link will be in blue with word "Parallelize" present above the link.

 

      I would suggest to try the below scenario specified in help document to understand the functionalities of tparallelize before applying it to your scenario.

 

https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/x6H8ibjgBJw3oAsRXeYk4g

 

Warm Regards,

 

Nikhil Thampi

 

 

View solution in original post

9 Replies
Anonymous
Not applicable

Can you show us a screenshot of your job?

Anonymous
Not applicable

Hi,

 

    I have created a skeleton diagram for your flow. Could you please check whether below flow is working in your case?

 

    0683p000009LzvT.png

 

 

Warm Regards,

 

Nikhil Thampi

abhi90
Creator II
Creator II
Author

Hi @nthampi, @rhall,

 

Thanks for your suggestion. I am yet to try your suggestion. But I think this will handle the failure case scenario.But can u tell me how to handle on whether how to run my filearchive Job only once after 3 jobs will complete. 0683p000009MACn.png 0683p000009Lzvd.jpgSuccessCase Scenario?As after all 3 Completition My Archival Job will run.

 

 

Anonymous
Not applicable

Hi,

 

     If the archive job is waiting for files from all three jobs, then you should add it to the synchronize flow. You can add a On Subjob Ok to mail component and archive the data.

 

Warm Regards,

 

Nikhil Thampi

abhi90
Creator II
Creator II
Author

Hi @nthampi,

No My Filearchive Job is not waiting for any of those 3. Yes FileArchive Job is in Synchronize(wait for All) Flow from tparallelize. But problem happening is Archival is happening 3 times.

Anonymous
Not applicable

Hi,

 

    Could you please add a diagram where you have added the archive component? It will provide detailed insight about the issue. It seems the three jobs are present before tparallelize.

 

Warm Regards,

 

Nikhil Thampi

abhi90
Creator II
Creator II
Author

Hi @nthampi, @rhall,

Please find the Drawing where I explained the scenario what I am trying to achieve.yes 3 Jobs are in parallel link with tparallelize. Also One thing archival have no dependency for file on Job1,Job2 and Job3

0683p000009LzXC.jpg

Anonymous
Not applicable

Hi,

 

     You are currently adding the subjobs before tparallelize component. This is the reason why three OnSubjobOK are present before your tparallelize component and are executing before paralelize component. If you observe my previous post, I have created parallel operations for child jobs after tparallelize component.

 

      If you are connecting a job correctly, the link will be in blue with word "Parallelize" present above the link.

 

      I would suggest to try the below scenario specified in help document to understand the functionalities of tparallelize before applying it to your scenario.

 

https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/x6H8ibjgBJw3oAsRXeYk4g

 

Warm Regards,

 

Nikhil Thampi

 

 

abhi90
Creator II
Creator II
Author

Hi @nthampi,

Yes that what problem lies. I removed those ONSUBJOBOK and added My Archival Job after previous tparallelize Component in Synchronize Flow(I missed that Screenshot).Marking your answer as Solution 0683p000009MACn.png