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 |
|
murrayb3024
Yak Posting Veteran
79 Posts |
 Posted - 2005-11-10 : 12:44:33
|
| I have a DTS package, it works fine if I execute it in Enterprise manager. I set up a scheduled job for it, but if I try to start that job it fails. So it works if I run the DTS package, but not if I try to run the job that calls the package. I read the error message and it says it is trying to execute the DTS package as a local user instead of a domain user. In the DTS I have some files moving to another server, so that is what is causing the failure. How can I get the scheduled job to run as a different user? |
|
|
lizak
Starting Member
12 Posts |
Posted - 2005-11-11 : 15:21:26
|
| First thing in troubleshooting would be to try to schedule a simple DTS that did nothing but create a log file. That would tell me if it was the specific DTS package or an overall authority problem.Likely it's an overall problem as this is a common situation people encounter. Short answer is the package is probably executing as the proxy account user. The following should help explain what's going on:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_pkgmng_sec_09dl.asp |
 |
|
|
juvethski
Starting Member
46 Posts |
Posted - 2005-11-19 : 03:48:07
|
| dont know if you have this fixed already. if not yet, this might help (which i read from here also). if you created the job, most likely you are the owner of the job. what i did is i just changed the owner to 'sa'. you can do this by right clicking the 'scheduled' job and select properties. click the 'owner' drop down list and select 'sa'.cheers.~~~~~~~~~~~~~~~~how's your data? |
|
|
|
|
|
|
DTS executing as local user...