July 10, 2003 at 10:11 am
I have a problem with a few DTS packages that is scheduled to run through the SQL Server Agent. Some of these packages fail. However, they work fine if I open up these DTS package in the Designer and Run it from there. I'm running it directly on the Server logging in as "administrator", instead of on my PC. It also works if I open up the DTS package and run it from other PC's as well. I've left the Built-in Admin group alone in SQL Server so that it still has SA rights to the db. SQL Server Agent is using a Win2000 AD Domain Account with admin rights.
There are other DTS jobs that are scheduled that works fine. It's just a handful that doesn't seem to want to work through the SQL Agent. There isn't anything wrong with the DTS packages that are failing because it works just fine if I:
1. Right-Click and "Execute Package" through Enterprise Manager
OR
2. Execute it from DTS Designer
OR
3. Run it with DTSRun through the DOS prompt
OR
4. Run it with DTSRUNUI
Almost all the scheduled jobs look something like this:
DTSRun /~Z0x0515A9752C419EB2682B47EE176B74537 etc...
I've replaced this encrypted step with the uncrypted version that works (in #3) when I run it manually through DOS. The result is still the same. It fails. This is the only step in the Job. It's actually a simple job.
All of these failed packages are faily simple using common DTS tasks. About the only thing that is above "simple" is establishing an ODBC connection to a IBM DB2 database on the mainframe.
These jobs never work properly through SQL Server Agent. Once in a while, when I Right-Click and "Start Job" manually, it does work with "Succeed ...".
I've just upgraded from Win2000 SP3 to Win2000 SP4 in hopes of fixing it, but everything is still the same.
Anyone know what else I can do to troubleshoot this? I can't figure out why it's not working and I really need to get this fixed. It's becoming a daily routine to have to manually run these packages each morning.
July 11, 2003 at 8:11 am
Hey, see my answer to your post in the Administration forum. Cheers.
Joseph
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply