Skip to content

Latest commit

 

History

History
44 lines (38 loc) · 2.65 KB

File metadata and controls

44 lines (38 loc) · 2.65 KB
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.component system-stored-procedures
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
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
caps.latest.revision 14
author stevestein
ms.author sstein
manager craigg

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