Return
-
Title
xp_slssqlmaint does not execute without a Plan ID. -
Description
LiteSpeed extended stored procedure (xp), which is similar to the SQL Server xp for Maintenance Plans (xp_slssqlmaint) does not execute without a Plan ID.
-
Cause
Plan ID, generated by the Graphical User Interface (GUI) is required.
-
Resolution
The Plan ID, which is generated from the LiteSpeed GUI, is required. Within the LiteSpeed GUI, the Plan ID would be generated similar to:
'CA0AE9C-5374-4803-B0A-DF2BBAD285'.
The LiteSpeed xp_slssqlmaint requires the GUI-generated plan id. Microsoft SQL Server xp_sqlmaint only requires the name of the database. -
Defect ID
CR0179137