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
 Timed Event??

Author  Topic 

mrtweaver
Yak Posting Veteran

67 Posts

Posted - 2010-02-12 : 10:44:03
Please help. I dont know if this is the correct terminology which is why I added the question marks in the subject line. What I would like to do is to run a query every sunday at noon.

So how can this be done and please put it in the most layman of terms being as I am still quite new to this. We are using MS SQL 2005.

I did try using the search in the menu bar above but it kept comming up server could not be found. Thanks for your assistance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-12 : 10:46:37
you need to schedule a sql agent job and set schedule at noon on sunday.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -