sp_delete_maintenance_plan_db (Transact-SQL)
Applies to: SQL Server
Disassociates the specified maintenance plan from the specified database.
Note
This stored procedure is used with database maintenance plans. This feature has been replaced with maintenance plans which don't use this stored procedure. Use this procedure to maintain database maintenance plans on installations that were upgraded from a previous version of SQL Server.
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Transact-SQL syntax conventions
Syntax
sp_delete_maintenance_plan_db
[ @plan_id = ] 'plan_id'
, [ @db_name = ] N'db_name'
[ ; ]
Arguments
[ @plan_id = ] 'plan_id'
Specifies the maintenance plan ID. @plan_id is uniqueidentifier, with no default.
[ @db_name = ] N'db_name'
Specifies the database name to be deleted from the maintenance plan. @db_name is sysname, with no default.
Return code values
0
(success) or 1
(failure).
Remarks
sp_delete_maintenance_plan_db
must be run from the msdb
database.
The sp_delete_maintenance_plan_db
stored procedure removes the association between the maintenance plan and the specified database; it doesn't drop or destroy the database.
When sp_delete_maintenance_plan_db
removes the last database from the maintenance plan, the stored procedure also deletes the maintenance plan.
Permissions
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
Examples
Deletes the maintenance plan in the AdventureWorks2022
database, previously added by using sp_add_maintenance_plan_db
.
EXEC sp_delete_maintenance_plan_db
N'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC',
N'AdventureWorks2022';
Related content
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin