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 |
|
humanpuck
Yak Posting Veteran
94 Posts |
 Posted - 2006-07-24 : 08:49:39
|
| How do you schedule a DTS package? I tried to just right click on the package and then try to schedule it, but the job won't run. Any ideas? |
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-07-24 : 10:18:12
|
| I've done some poking around and from what I've read they say the SQL Sever Agent service "owns" the job, and whatever login is being used in the agent has to have SQL Server Access, is that true? |
 |
|
|
humanpuck
Yak Posting Veteran
94 Posts |
Posted - 2006-07-24 : 10:27:49
|
| Ok if anyone else runs into this same problem, here's an article about the issue and the resolution.http://support.microsoft.com/?kbid=269074 |
|
|
|
|
|
|
Scheduling a DTS Package