Script out all alerts

  • Carolyn Richardson

    SSCrazy Eights

    Points: 8352

    Comments posted to this topic are about the item Script out all alerts

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • Nadrek

    SSC-Insane

    Points: 20039

    Thank you for the script, Carolyn; both sets of SQL Statements (the alerts and the notifications) work well on SQL 2012, both on error number and severity level based alerts.

    One note to any users is that while the generated scripts do check for any sysalert of the same name, they do not check for any alert on the same condition, which results in an error if the script attempts to put a sysalert of a different name on a condition that a given server already has a differently named alert for.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Nadrek (9/23/2014)


    Thank you for the script, Carolyn; both sets of SQL Statements (the alerts and the notifications) work well on SQL 2012, both on error number and severity level based alerts.

    One note to any users is that while the generated scripts do check for any sysalert of the same name, they do not check for any alert on the same condition, which results in an error if the script attempts to put a sysalert of a different name on a condition that a given server already has a differently named alert for.

    Thanks for the additional hints.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Nadrek (9/23/2014)


    Thank you for the script, Carolyn; both sets of SQL Statements (the alerts and the notifications) work well on SQL 2012, both on error number and severity level based alerts.

    One note to any users is that while the generated scripts do check for any sysalert of the same name, they do not check for any alert on the same condition, which results in an error if the script attempts to put a sysalert of a different name on a condition that a given server already has a differently named alert for.

    Thanks for the heads up.

Viewing 5 posts - 1 through 5 (of 5 total)

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