Setting Up Notifications for Alert

You can use a stored procedure to set up a notification for an alert.

An RDS for SQL Server DB instance has been connected. Connect to the DB instance through the SQL Server client.

Run the following commands to set up notifications for the alert:

EXEC [msdb].[dbo].[rds_add_notification]

@alert_name='alert',

@operator_name='operator',

@notification_method= notification_method;

Table 1 Parameter description
Parameter	Description
'alert'	The alert for this notification. alert is sysname, with no default.
'operator'	The operator to be notified when the alert occurs. operator is sysname, with no default.
notification_method	The method by which the operator is notified. notification_method is tinyint, with no default. notification_method can be one or more of these values combined with an OR logical operator. 1: E-mail 2: Pager 4: net send

After the command is executed, the system displays the following information.

Commands completed successfully.

The following figure shows an example command output.

Была ли эта статья полезна?