Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I want to fire a procedure every 2 seconds
- Thread starter sdfgher
- Start date
I suppose you could have a main procedure that uses WAITFOR DELAY and EXECs another SP every two seconds, but it would really have no exit point unless you built one in.
I don't know what the granularity of SQL Server Agent's scheduler is, but I wouldn't think it terribly reliable as to firing exactly every two seconds.
Why do you want to do this? Robert Bradley
I don't know what the granularity of SQL Server Agent's scheduler is, but I wouldn't think it terribly reliable as to firing exactly every two seconds.
Why do you want to do this? Robert Bradley
- Status
Similar threads
- Locked
- Question