Post reply

Alert not working

  • March 23, 2004 at 9:11 am

    #86306

    I set up an alert in SQL Server Agent to notify me when error 1205 is encountered. I included the operator name and setup to be notified by email.

    It is a SQL Server event alert, I have had several deadlocks already, but was never notified, and in the History of the alert it shows occurrence count: 0

    Am I missing something obvious?

    Thanks is advance for your help.

     

  • March 26, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 26, 2004 at 9:50 am

    #500690

    Is the agent started?

  • March 26, 2004 at 10:05 am

    #500693

    Yes, agent is started.

    I do receive an email when a job fails, but the alert does not seem to work.

    Thanks

  • March 26, 2004 at 1:35 pm

    #500738

    DId you verify that 1205 did occurr. I have seen deadlocks that were ended by other things than being vicitimized. Might also want to turn on trace flag 1204 to write deadlock events to the sql logs to see what all happens. Might be something handling before the 1205 occurrs.

  • March 26, 2004 at 1:53 pm

    #500748

    I do have flag 1204 turned on and I see the 1205 in the report, but for some reason I am never notified and the alert is not aware that the deadlock ocurred.

    Thanks

  • March 26, 2004 at 1:54 pm

    #500749

    Ok, then in Alerts view in EM what does it show Enabled?

  • March 26, 2004 at 2:00 pm

    #500751

    Yes it is enabled.

  • March 26, 2004 at 2:23 pm

    #500756

    I jst tested and got the same issue. I think something is missing. I don;t know right off what but something.

  • October 11, 2004 at 11:49 am

    #526225

    Did anyone every figure this out?  I'm having the same problem.  I set up an alert for error 1205 and then run a test script which causes a deadlock.  I never receive a notification and the error count in EM is never incremented.  I did a test by setting up an alert for errro 208 (Invalid Object) and it works correctly.

    Is there anything special that needs to be done to get the deadlock alert to work?

    Thanks,

    Leo

  • June 13, 2005 at 1:54 pm

    #565108

    Has anyone figured this one out yet.  I'm having same problem. 

    Trace flag is set

    alert is enabled

    I caused an error 1205 and did not receive the alert.




    Curtis Smith
    SQL Server DBA
    Well in worked in Theory ...

  • June 14, 2005 at 12:04 am

    #565172

    my 2ct

    - did you stop and restart sqlagent _after_ you enabled the (first) alert ?

    - also add traceflag 3605 for more deadlockinfo in the sqlservereventlog.

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • August 30, 2005 at 11:47 am

    #586243

    Hello everyone ... has anyone found a resolution to this problem?

    I get notified with other alerts i setup but not the Deadlock 1205 alert. Please advise.

  • August 30, 2005 at 2:46 pm

    #586295

    I was the original post.  If I remember correct this is a documented problem is Sql Server.  Stop and restart the SQL Server and the problem is corrected.




    Curtis Smith
    SQL Server DBA
    Well in worked in Theory ...

  • August 30, 2005 at 4:19 pm

    #586313

    Hi Curtis,

    Thanks for the reply. I can't seem to find it in Microsoft's site. I'll keep searching. Would it be possible to point me to the right direction on seaching for this document.

    Thanks again.

    Steve

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply