Loop condition

[laiko]

I need to create a job that waits for a row with the value of current date to appear before the load can proceed. Say, the table is Load_Schedule and it has only one field called 'Load_date'. My job should wait for 1 hour for the Load_date to have a value equal to sysdate before it proceeds to the next stage. How do I do this??

[ray.wurlod]

What happens if the hour elapses with no such file?

I'd run a job sequence with a loop containing a WaitForFile activity followed by a Job activity to process the file to determine what its date is, then probably a Nested Condition activity to check whether it's the right date.

[chulett]

Except there's no file.

I'd do something similar in a loop, but rather than WFF call a Server job that checks the table and passes back in USERSTATUS whether the condition was met or not. Add a 'sleep' Routine Activity so it doesn't just race around in the loop at high speed. Branch out of the loop when the condition is met and on to your followup processing steps or let the loop end naturally after your 60 minute window is up and go to your error condition.

[laiko]

Sorry, forgot to mention it has to wait max 5 hours. I was able to create the sequence however, the problem i see is that everytime the job that checks the table is called, it creates logs. If I have to loop every min for 5 hours, it will create the log 300x (max). Is that a good design???

[ray.wurlod]

It's probably bearable particularly if you have a short auto-purge interval. Otherwise create your own custom routine or job control code.

[chulett]

I don't see an issue, provided as noted that you stay on top of the runs with an appropriate auto-purge setting.

[laiko]

Thanks, guys.. That's what am also thinkin' - purge regularly.