Updated: June 10, 2016
Associates a database with a maintenance plan.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
|Applies to: SQL Server (SQL Server 2008 through current version).|
sp_add_maintenance_plan_db [ @plan_id = ] 'plan_id' , [ @db_name = ] 'database_name'
[ @plan_id =] 'plan_id'
Specifies the plan ID of the maintenance plan. plan_id is uniqueidentifier, and must be a valid ID.
[ @db_name =] 'database_name'
Specifies the name of the database to be added to the maintenance plan. The database must be created or exist before its addition to the plan. database_name is sysname.
0 (success) or 1 (failure)
sp_add_maintenance_plan_db must be run from the msdb database.
Only members of the sysadmin fixed server role can execute sp_add_maintenance_plan_db.
This example adds the AdventureWorks2012 database to the maintenance plan created in sp_add_maintenance_plan.
EXECUTE sp_add_maintenance_plan_db N'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC',N'AdventureWorks2012';