June 27, 2011 at 9:39 am
I have a DTS package which is executed every Wednesday and Friday at 15:00 from the SQL Agent using the same windows service account as the SQL server which is sysadmin and local admin on the server.
The job has worked fine for the last 3 years but for no apparent reason the it has stopped. The SQL Agent job just hangs when it is started, it doesn't seem like the DTS package is being executed at all. If I log on to the SQL server I'm able to run the DTS package manually without a hitch.
I've looked at all angles Check access permissions on the server, SQL server folders etc and it all seems fine, has anyone ever seen this or know how to fix it.... I'm pulling my hair out here :crazy:
June 27, 2011 at 10:19 am
1. What patches were added about the time this stopped working?
2. Login AS the user SQL uses and try to execute it interactively on the server that way. You might see something different.
3. Any other packages acting funny?
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply