February 27, 2003 at 9:18 am
What i would like to be added is the ability to run a job in Seconds.
I have a job that i need to run every 10 Seconds.
February 27, 2003 at 10:34 am
Here is what I might do:
1) Add a job that never end, and all it does is run your process every ten seconds.
or
2) Add a job that never ends, and all it does is run sp_start_job every ten seconds to start you agent job that you want to run every ten seconds
Plus you might want to make a wish to SQL Server that the scheduling frequency be changed to include seconds.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
February 27, 2003 at 12:47 pm
If you're running that frequently, maybe a better solution would be to use a loop with a delay built in? Or build the job as a service that runs continuously. Would think you'd pay a price for starting (or trying to) a job that that often.
Andy
March 3, 2003 at 6:26 pm
What kind of job is it?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply