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

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
Database Maintenance Plan stored procedures (Transact-SQL)	Database Maintenance Plan stored procedures (Transact-SQL)	MashaMSFT	mathoma	randolphwest	08/21/2024	sql	system-objects	reference	database maintenance plans [SQL Server] system stored procedures [SQL Server], database maintenance plans maintenance plans [SQL Server], stored procedures	TSQL

Database Maintenance Plan stored procedures (Transact-SQL)

[!INCLUDE SQL Server]

[!INCLUDE ssNoVersion] 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 don't use these stored procedures. Use these procedures to maintain database maintenance plans on installations that were upgraded from a previous version of [!INCLUDE ssNoVersion].

[!INCLUDE ssNoteDepFutureAvoid]

• sp_add_maintenance_plan
• sp_add_maintenance_plan_db
• sp_add_maintenance_plan_job
• sp_delete_maintenance_plan
• sp_delete_maintenance_plan_db
• sp_delete_maintenance_plan_job
• sp_help_maintenance_plan
• sp_delete_maintenance_plan

Related content

• System stored procedures (Transact-SQL)
• Maintenance plans