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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-08-30 : 15:09:29
|
I have created a scheduled job that runs a DTS package but it fails every time that I start the job. In the Job history it says: The job failed. The Job was invoked by User DEV\sqladmin. The last step to run was step 1 (dt_SA_LoadSQLTablesFromAccess). I am able to execute the DTS package. The job owner is a system admin user id. The Dev\sqladmin is a Windows admin ID and I used it to log into the server. What’s the problem and how can I fix it?Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
CanadaDBA
583 Posts |
Posted - 2005-08-31 : 07:59:23
|
| Tara, I checked the link. I am sure there is a permission problem but I can't resolve it. I am working on the server through RDC (Terminal Services). And the job owner is a sys admin user id. I start the job manually and it fails and gives me the above message. Note that the Dev\sqladmin is the SQL Server's service user id.Canada DBA |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-08-31 : 13:51:25
|
| It is strange! I scheduled another DTS package and it worked while still the other one fails. I have checked every login and have changed to the service user id. What's wrong?Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-09-01 : 10:54:35
|
| Discovered the problem! There was a S: drive mapping in my session that it didn't exist when the DTS was being called by the scheduled job or from within a SP. I changed it to UNC and everything is fine and working! :)Canada DBA |
|
|
|
|
|
|
Scheduled job fails