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

title	Database Maintenance Plan Stored Procedures (Transact-SQL)
description	Database Maintenance Plan stored procedures (Transact-SQL)
author	MashaMSFT
ms.author	mathoma
ms.reviewer	randolphwest
ms.date	06/23/2025
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
helpviewer_keywords	database maintenance plans [SQL Server] system stored procedures [SQL Server], database maintenance plans maintenance plans [SQL Server], stored procedures
dev_langs	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