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.
| Author |
Topic |
|
pug2694328
Posting Yak Master
166 Posts |
 Posted - 2006-09-25 : 11:28:46
|
| Is there a way to set some TSQL to run on a schedule?I'd like to run some code every weekday at 1pm. I know I can setup a third party program to submit the query, but am wondering if SQL Server has some built in functionality.Any help is greatly appreciated! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-25 : 11:33:05
|
You don't need third party software to do this. SQL Server has build in feature - SQL Agent. If you are using SQL Server 2000, launch Enterprise Manager, navigate to Management - SQL Server Agnet - Jobs - Add Jobs
KH |
 |
|
|
pug2694328
Posting Yak Master
166 Posts |
Posted - 2006-09-25 : 13:41:36
|
| Rock! This works like a charm. |
|
|
|
|
|
|
Schedule a Query to Run