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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Autorun script?

Author  Topic 

tech1
Starting Member

49 Posts

Posted - 2010-06-15 : 08:15:44
I need to run a script which will update records with a condition.

I want to be able to run this script automatically in SQL server every say, 2 hours?

is it possible to do this in SQL 2005? if so - how?

Thanks!

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-15 : 08:19:14
Create a Job in SQL Server Agent and schedule it.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-15 : 08:24:05
See here:
http://mbsguru.blogspot.com/2009/05/scheduling-jobs-in-sql-2005.html


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

tech1
Starting Member

49 Posts

Posted - 2010-06-15 : 09:04:22
thought so, just done it :-) Works great!
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-15 : 09:06:59
Glad to help


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -