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 |
|
-Dman100-
Posting Yak Master
210 Posts |
 Posted - 2007-01-10 : 15:02:13
|
| I am testing a scheduled package that I created and cannot get it to run via the scheduler. I can manually execute it and runs fine. I've doubled checked to verify that SQL Agent is running...it is.I believe the problem is related to ownership and roles.I'm connecting to the server remotely and my login has system administrator role priviledges.when I create the dts package, it lists the owner as my windows login.Are there other things I should check to isolate why the package won't run from the scheduler?Thanks for any help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-10 : 16:47:49
|
| When a DTS package runs via a job, it uses the MSSQLSERVER service account. To see what is going on, log in directly to the database server using this service account, then run the package.Tara Kizer |
 |
|
|
|
|
|
scheduled job fails