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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply