twaitforsqldata component clarification

[BA621858188]

Hi All,

I am looking to clarify my understanding of the below points. Please help me here.

I am using the twaitforsqldata component, and max iterations as empty means infinite; each iteration takes 5 minutes, and it is waiting for the data on one table based on certain conditions. I wanted to know if the data didn't arrive in the table until 14+ hours, then the job would fail, or if it would still run every 5 minutes to check the availability of the data.

Please let me know if there are any additional things we need to consider so that our job won't fail.

Thanks in advance.

[Anonymous]

Hi

Depends on the 'Trigger action on rowcount' condition and 'Then' action, if you set the rowcount equals 0 and then exit loop, the component will exit the loop.

Regards

Shong

[BA621858188]

Hi @Shicong Hong​ ,

rowcount is set to 1, and the exit loop is selected.

[Anonymous]

if there is no data coming, the rowcount is 0, the loop will continue to run every 5 minutes.