.png)
How to: Create an Alert Using Severity Level (SQL Server Management Studio)
This topic describes how to create a Microsoft SQL Server Agent alert that is raised when an event of a specific severity level occurs.
-
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-
Expand SQL Server Agent.
-
Right-click Alerts and select New Alert.
-
In the Name box, type a name for this alert.
-
In the Type box, click SQL Server event alert.
-
Check the Enable check box to enable the alert to run. By default, Enable is checked.
-
In the Database name list, click the database to restrict the alert to a specific database.
-
Click Severity, and then click a severity level.
-
Severity levels from 19 through 25 send a SQL Server message to the Microsoft Windows application log and trigger an alert. Events with severity levels less than 19 will trigger alerts only if you have used sp_altermessage, RAISERROR WITH LOG, or xp_logevent to force them to be written to the Windows application log.
-
Check Raise alert when message contains box, and type a keyword or character string in the Message text box to restrict the alert to a particular character sequence. The maximum number of characters is 100.
