August 29, 2002 at 11:36 am
I am currently using SQL Agent to kick off an sp every minute. The sp basically reads a que table and runs a process for each row it finds. I'd like to run this more often than every minute, but can't with SQL Agent. Is there a 3rd party tool, or some SQL trick, to do this?
BC
BC
August 29, 2002 at 12:18 pm
Set the process to on success run the same step or step 1. Then in the step add a WAITFOR DELAY '000:00:10' to have the process pause for 10 secounds. See BOL for more details.
The only thing to remember is it will always look like the job is running until it fails or is stopped.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 08/29/2002 12:19:12 PM
August 29, 2002 at 1:04 pm
You can build into the process using a WHILE loop or something of that nature checking for an entry on a table. If it finds that entry, the process stops itself gracefully.
So when you're ready to have the process stop, you insert the record into the table and after at most one more interation, it quits.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply