Help Center > > User Guide> Working with RDS for SQL Server> Usage of Stored Procedures> Updating Alert Notification Methods

Updating Alert Notification Methods

Updated at: May 26, 2020 GMT+08:00

Scenarios

You can use a stored procedure to update the notification method of an alert notification.

Prerequisites

An RDS Microsoft SQL Server DB instance has been connected. Connect to the DB instance through the Microsoft SQL Server client. For details, see Connecting to a DB Instance Through a Public Network.

Procedure

Run the following commands to update the notification method of an alert notification:

EXEC [msdb].[dbo].[rds_update_notification]

@alert_name = 'alert',

@operator_name ='operator',

@notification_method =notification ;

Table 1 Parameter description

Parameter

Description

'alert'

The name of the alert associated with this notification. alert is sysname, with no default.

'operator'

The operator who will be notified when the alert occurs. operator is sysname, with no default.

notification

The method by which the operator is notified. notification is tinyint with no default, and can be one or more of the following values:

  • 1: E-mail
  • 2: Pager
  • 4: net send
  • 7: All methods

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

Commands completed successfully.

Example

The command output is as follows.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel