Help Center> Relational Database Service> User Guide> Working with RDS for SQL Server> Usage of Stored Procedures> Removing Operators
Updated on 2023-08-09 GMT+08:00
View PDF

Removing Operators

Scenarios

You can use a stored procedure to remove an operator.

Prerequisites

An RDS for SQL Server DB instance has been connected. Connect to the DB instance through the 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.