Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    38

    Post Unanswered: Email SQL Server Event Alert : Deadlock : SQL 2005

    Hi folks,

    I was looking for some help in setting up alerts for deadlocks in 2005 ( SP2) .

    This is what I did

    1) set DBCC traceon 1222 ( global )
    2) created a SQL Server Event alert ( error # 1205 .. also tried with 1222)
    3) set the response (on the ALERT ) to run a job for emailing me on the same

    Now when I simulate the deadlocks; though the error log gets written down with all the info, the job for emailing never gets executed.

    I was wondering if you guys can review and help.

    Also, would it be possible to email the deadlock information in the SQL error log as a graph ( like the one we see in the profiler ) ..

    Thanks in advance!

    Warm Regards,
    RanjitSHans
    Last edited by RanjitSHans; 06-26-09 at 16:55.

  2. #2
    Join Date
    May 2006
    Posts
    38

  3. #3
    Join Date
    Jun 2009
    Location
    CA, USA
    Posts
    59
    MohammedU
    SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •