Post reply

Alerts won't work!

  • September 15, 2011 at 9:47 am

    #244888

    Okay,

    1.created alert

    2.it is enabled

    3.type is SQL Server event alert

    4.switched to the correct database and/or all databases

    5.i have tried severity 015 and 016

    6.tried executing a job after it fires.

    7.tried emailing an operator after it fires.

    8.Delay between responses, 0 minutes,0seconds.

    The operator does work because I have sent notifications when a job failse through it.

    I should be able to get an alert to fire off from SSMS right?

    Any help would be appreciated.

  • September 15, 2011 at 6:01 pm

    #1382335

    Check this

    http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

    Thank You,

    Best Regards,

    SQLBuddy

  • September 16, 2011 at 10:54 am

    #1382677

    Yep found out the reason,

    I needed to use the WITH LOG after my RAISEERROR function call. Severity 16.

    All severities under 19 are not automatically written to the error log.

    Nice little article explaining it.

    [/url]

    Also thank you SQLBuddy, that article lead me to my answer somehow. 😎

  • September 16, 2011 at 5:01 pm

    #1382826

    Good Job! Nice to know that ..

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 4 posts - 1 through 3 (of 3 total)

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