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 |
|
homeguard
Starting Member
32 Posts |
 Posted - 2007-04-30 : 16:17:17
|
| I'm new to SQL Server 2000 and i was wondering how i could schedule a SQL query to run every night round midnight?I am looking to throw the info in an Access DB and store it on a shared drive.Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-30 : 16:21:56
|
| Create a scheduled sql job to run your query, you can find how to create job in books online. |
 |
|
|
homeguard
Starting Member
32 Posts |
Posted - 2007-04-30 : 16:33:10
|
| do you happen to have a link to any good tutorials? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-30 : 16:42:50
|
| Books Online.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Scheduling a SQL query every night