May 9, 2008 at 10:41 am
Visual Studio has a timer control that can be used to run any proc periodically. Does SQL Server have a similar timer to allow periodic execution of a stored proc?
May 9, 2008 at 10:44 am
Yes, schedule it to run in a job.
May 9, 2008 at 10:50 am
Thanks Jim.
May 12, 2008 at 6:42 am
It's called SQL Server Agent and it runs as a seperate service on all server installs (it's not in Express or Compact).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply