DTS package & Scheduled Job | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS package & Scheduled Job

In my shop I have a DTS package scheduled at early hours of the day. It failed today with a deadlock error and I had to re run the job and it failed again saying deadlock situation. I can’t kill the process which is another important process happening at that time (blocking process). So, I decided to run the DTS package manually, and to my surprise it ran successfully without any deadlock errors, at that time the blocking process is still alive. Here, I had a question would the deadlock situations be captured in DTS pakcage run manually or automated ? Or is there something else which I need to know. Thanks in advance RoyalSher.
*********
The world is the great gymnasium where we come to make ourselves strong.
What is the value of query wait option in sp_configure?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Use following KBAs to monitor the blocking
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509 – for SQL 2000 blocking
http://support.microsoft.com/default.aspx?scid=kb;EN-US;251004 – for SQL 7 blocking And also try to capture the activity by running PROFILER while package is executed via SQLAgent. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>