O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Alerts

Alerts provide the capability to send notification or perform actions based upon events or conditions that occur either within the SQL Server instance or on the machine hosting your instance.

Alerts can be configured as one of the following three types:

  • SQL Server event

  • Performance Condition

  • Windows Management Instrumentation (WMI) event

An alert is raised for a SQL Server event based on either an error number or an error severity level. You can additionally restrict the alert to a specific database or a specific text string within an error message. When a SQL Server event alert is created, the SQL Server Agent scans the Windows Application Event Log to look for matches to the event criteria that you have defined. For example, you could ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required