Removing Alerts
Scenarios
You can use a stored procedure to remove an alert.
Prerequisites
An RDS for SQL Server DB instance has been connected. Connect to the DB instance through the SQL Server client.
Procedure
Run the following commands to remove an alert:
EXEC [msdb].[dbo].[rds_delete_alert]
@name='name';
Parameter | Description |
---|---|
'name' | The name of the alert. This parameter is of sysname data type, with no default value. |
After the command is executed, the system displays the following information.
Commands completed successfully.
Example
EXEC [msdb].[dbo].[rds_delete_alert]
@name='test';
The command output is as follows.
Parent topic: Usage of Stored Procedures
- Scenarios
- Prerequisites
- Procedure
- Example