Calls the sqlmaint utility with a string containing sqlmaint switches. The sqlmaint utility performs a set of maintenance operations on one or more databases.
xp_sqlmaint 'switch_string'
The -? switch is not valid for xp_sqlmaint.
None. Returns an error if the sqlmaint utility fails.
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 NT Authentication, switch_string is passed without change to sqlmaint.
Execute permissions are restricted to members of the sysadmin fixed server role.
In this example, xp_sqlmaint calls sqlmaint to perform integrity checks, create a report file, and update msdb.dbo.sysdbmaintplan_history.
EXEC xp_sqlmaint '-PlanID 02A52657-D546-11D1-9D8A-00A0C9054212
-Rpt "C:\MSSQL7\LOG\DBMaintPlan2.txt" -WriteHistory -CkDB -CkAl'
Here is the result:
The command(s) executed successfully.
sqlmaint Utility | System Stored Procedures |