Wait and Iterate a sql query

One Star

Wait and Iterate a sql query

Hi All,
I am having a difficulty in iterating a sql query in Talend Data integration tool. My Scenraio goes like this..
I am loading a set of files into the server and the corresponding job will get triggered. I need to wait until the job gets success/failure and then proceed for further validations.
I need to iterate for a status column to be updated in the job table in the intervals of 5 mins and then check again. I need to wait then iterate then check till the status column has been updated with Success/Failure.
Only when the job status is updated with a value then only the Talend job should do further actions.
Please help me!!
Seventeen Stars

Re: Wait and Iterate a sql query

tWaitForSql --(iterate)--> tFileList --(iterate)-->tFileInputdelimited --(main flow)--> ......
Only a suggestion ;-)

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

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch