Help Center/ Relational Database Service_RDS for SQL Server/ User Guide/ Usage of Stored Procedures/ Removing Operators
Updated on 2025-06-30 GMT+08:00
View PDF
Share

Removing Operators

Scenarios

You can use a stored procedure to remove an operator.

Prerequisites

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

Procedure

Run the following commands to remove an operator:

EXEC [msdb].[dbo].[rds_delete_operator]

@name='name',

@reassign_to_operator = 'reassign_operator';

Table 1 Parameter description

Parameter

Description

'name'

The name of the operator to delete. This parameter is of sysname data type, with no default value.

'reassign_operator'

The name of an operator to whom the specified operator's alerts can be reassigned. This parameter is of sysname data type, with a default value of NULL.

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

Commands completed successfully.

Example

EXEC [msdb].[dbo].[rds_delete_operator]

@name = N'Test01',

@reassign_to_operator = NULL;

The command output is as follows.

Parent Topic: Usage of Stored Procedures