database-maintenance-plan-stored-procedures-transact-sql.md

title	Database Maintenance Plan Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	database maintenance plans [SQL Server] system stored procedures [SQL Server], database maintenance plans maintenance plans [SQL Server], stored procedures
ms.assetid	f5f658e3-417e-4286-9213-5738266f3b28
author	MashaMSFT
ms.author	mathoma

Database Maintenance Plan Stored Procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

[!INCLUDEmsCoName] [!INCLUDEssNoVersion] supports the following system stored procedures that are used to set up maintenance tasks. These stored procedures are used with database maintenance plans. This feature has been replaced with maintenance plans which do not use these stored procedures. Use these procedures to maintain database maintenance plans on installations that were upgraded from a previous version of [!INCLUDEssNoVersion].

[!INCLUDEssNoteDepFutureAvoid]

sp_add_maintenance_plan	sp_delete_maintenance_plan_db
sp_add_maintenance_plan_db	sp_delete_maintenance_plan_job
sp_add_maintenance_plan_job	sp_help_maintenance_plan
sp_delete_maintenance_plan

See Also

System Stored Procedures (Transact-SQL)
Maintenance Plans