Help Center/ Relational Database Service/ User Guide (ME-Abu Dhabi Region) / Working with RDS for SQL Server/ Usage of Stored Procedures/ Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators
Updated on 2023-07-06 GMT+08:00

Removing SQL Server Agent Notification Definitions for Specific Alerts and Operators

Scenarios

You can use a stored procedure to remove a SQL Server Agent notification definition for a specific alert and operator.

Prerequisites

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

Procedure

Run the following commands to remove the SQL Server Agent notification definition for a specific alert and operator:

EXEC [msdb].[dbo].[rds_delete_notification]

@alert_name = 'alert',

@operator_name ='operator';

Table 1 Parameter description

Parameter

Description

'alert'

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

'operator'

The name of the operator. operator is sysname, with no default.

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

Commands completed successfully.

Example

The command output is as follows.