Script out all alerts

Question

Script out all alerts

Carolyn Richardson

SSCrazy Eights

Points: 8357
More actions
May 15, 2014 at 5:15 pm

#291480

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]

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

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

Nadrek SSC-Insane Points: 20039 More actions · Answer 1

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 More actions · Answer 2

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 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

April 6, 2016 at 6:28 am

#1870117

Thanks for the script.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

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.