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 |
|
Vanny
Starting Member
9 Posts |
 Posted - 2009-02-05 : 10:30:25
|
| I figured doing this would be as simple as setting up a scheduled task in Windows Server, I guess it's not. I am simply trying to setup a scheduled job that executes a SQL script every day. The file comes in daily, and has the possibility of being slightly changed, it contains valid SQL, but does not end with .SQLI just want to schedule the execution of the SQL within that file.Can someone give me fairly detailed instructions on how to accomplish this? It would be much appreciated. Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-05 : 10:36:42
|
| Look for SQLCMD |
 |
|
|
|
|
|
Schedule a job to execute a file daily