Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to automate when a stored procedure executes?

Author  Topic 

Aleph_0
Yak Posting Veteran

79 Posts

Posted - 2011-06-30 : 17:59:07
Hi again, thanks for all your help so far!

I wanted to be able to have a stored procedure execute after business hours when I'm away from the computer (well, my work computer, at least). How do I do this? I've been reading up on triggers, but from what I understand they only execute when a table is modified.

I appreciate the help!

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-06-30 : 18:06:39
You could use SQL agent.
http://msdn.microsoft.com/en-us/library/ms189237.aspx
Go to Top of Page
   

- Advertisement -