Unanswered: SS Agent Alerts - Deadlock Event detection
I have setup the following in an attempt to trace deadlocks on event ocurrance. I'm using SS05 / SP3 Standard 64-bit on Win 2003/R2.
1. SS Agent alert setup on Error number: 59103 (deadlock)
2. Response is setup to invoke a sql server trace
3. Trace is an SS Agent job
-- this works, been tested standalone, and traces for 1 minute, logging trace file to the file system
I create a deadlock with test code ..
no trace, no nothing ..
Anyone have any idea why this doesn't capture the deadlock, or, if you have another method to capture the event, and invoke the job, I'll try that too.