Elegant way to stop a job when there's a row in a tbl?
Posted: Fri Mar 11, 2005 5:26 pm
I need to extract data from a MS Sql table, but I want to do it only if there's a 'load completed' semaphore row in the table. In addition, I want to retry the job once every 15 minutes for one hour. If after an hour the row doesn't exist, I exit with a successful completion code.
If I do a 'before sql' query to see if the row exists, there's no mechanism to gracefully exit the stage/job...or maybe there is and I don't know it (which is entirely possible!).
How would you all execute this?
Thanks,
cbres00
If I do a 'before sql' query to see if the row exists, there's no mechanism to gracefully exit the stage/job...or maybe there is and I don't know it (which is entirely possible!).
How would you all execute this?
Thanks,
cbres00