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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-24 : 07:42:37
|
| Katarina writes "Hi there,I have a problem with sql job - it fails. When I try to execute each step on its own it works fine with no errors. How is this possible? BTW, the job fails on the step which executes a dts package. The same dts package executes without errors.ThanksKatarina" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-02-24 : 12:33:13
|
| The tricky part with DTS is that when you test your DTS package from the designer, it runs under the security context of the user you are logged in as. However, when it gets kicked off from the SQLagent scheduler, the job will run from whatever user sqlagent runs under. Many times this is going to be the local system account, which most likely doesn't have rights to things like fileshares on your network.-ec |
 |
|
|
Soumen Dey
Starting Member
20 Posts |
Posted - 2005-02-25 : 23:32:12
|
| Hi,Even I have the same problem , but I 've changed from SQL server Agent service from localsystem to domain\administrator, but still it is not working. Can any body suggestany help |
|
|
|
|
|
|
sql job fails