August 26, 2009 at 3:26 pm
I have a polling/processing job that runs every 5 minutes. Currently the job can take 5 seconds to about 80 seconds depending on the work needed to be done.
If a particular job took more than 5 minutes would the next job start on time or would it be delayed? I'd like to skip the job if the previous one was still running.
Thanks if you can help, Emily
August 26, 2009 at 3:34 pm
it would not start until the previous run is finished .... you could test this out on a test box to have a working select statement and then a waitfordelay in your job that exceeds the scheduled run ... and see for yourself 🙂
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 3:55 pm
Okay thanks, I wasn't aware of waitfordelay
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply