---
title: "xp_sqlmaint (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"
f1_keywords: 
  - "xp_sqlmaint"
  - "xp_sqlmaint_TSQL"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "xp_sqlmaint"
ms.assetid: bda66e1b-6bbd-49be-b86e-37efc920e912
author: MashaMSFT
ms.author: mathoma
---
# xp_sqlmaint (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  Calls the **sqlmaint** utility with a string that contains **sqlmaint**switches. The **sqlmaint** utility performs a set of maintenance operations on one or more databases.  
  
> [!NOTE]  
>  [!INCLUDE[ssNoteDepFutureAvoid](../../includes/ssnotedepfutureavoid-md.md)]  
  
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
  
## Syntax  
  
```  
  
xp_sqlmaint 'switch_string'     
```  
  
## Arguments  
 **'** *switch_string* **'**  
 Is a string containing the **sqlmaint** utility switches. The switches and their values must be separated by a space.  
  
 The **-?** switch is not valid for **xp_sqlmaint**.  
  
## Return Code Values  
 None. Returns an error if the **sqlmaint** utility fails.  
  
## Remarks  
 If this procedure is called by a user logged on with SQL Server Authentication, the **-U "***login_id***"** and **-P "***password***"** switches are prepended to *switch_string* before execution. If the user is logged on with Windows Authentication, *switch_string* is passed without change to **sqlmaint**.  
  
## Permissions  
 Requires membership in the **sysadmin** fixed server role.  
  
## Examples  
 In the following example, `xp_sqlmaint` calls `sqlmaint` to perform integrity checks, create a report file, and update `msdb.dbo.sysdbmaintplan_history`.  
  
```  
EXEC xp_sqlmaint '-D AdventureWorks2012 -PlanID 02A52657-D546-11D1-9D8A-00A0C9054212   
   -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\DBMaintPlan2.txt" -WriteHistory  -CkDB -CkAl';   
```  
  
 [!INCLUDE[ssResult](../../includes/ssresult-md.md)]  
  
```  
The command(s) executed successfully.  
```  
  
## See Also  
 [sqlmaint Utility](../../tools/sqlmaint-utility.md)   
 [System Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/system-stored-procedures-transact-sql.md)