SQL Server Performance Forum – Threads Archive
DTS Failed
I have scheduled a DTS to run at 2PM and 6 PM. It runs fine at 6PM but fails at 2PM. Is there a way to find out why it fails at 2PM? Thanks BugmeCHeck the SQLAgent job history and DTS log for more information.
KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;269074&sd=tech fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
By looking at the job history, it seems like the job failed while copying data from database to database. I manually ran it and it worked fine. The DTS is working becuase it runs fine at 6PM but not 2PM. Is it possible that it fails copying the data at 2PM because users are in the system using the tables? I can’t think of any other reason for it to fail at 2PM but not 6PM. Any suggestion? Thanks Bugme
What was the error reported?
True and that gives more idea.
Make sure there are no network issues during that stipulated time, ensure the SQLAgent has required privileges to copy the files between the servers. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
The error simply stated…. "Process Exit Code 1. The step failed."
The two databases are resided on the same server. So, there shouldn’t be any privileges problem, right?
Enable the DTS package logging for more information on the error, refer to books online to enable the logging for DTS. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>