How to create the Maintenance Plan manually.
Only the LiteSpeed Maintenance Plan (MP) Graphical User Interface in Enterprise Console should be used to create maintenance plans. Once the MP is created in the Enterprise Console (EC), the t-sql of the job step in the MP may be viewed under the SQL Server Agent job, within the SQL Server Enterprise Manager tool.
Scripts cannot be created manually since the syntax for the LiteSpeed extended stored procedure xp_slssqlmaint is not the same as the syntax of native SQL Server xp_sqlmaint. For example, the creation of the Plan ID. This is generated from the LiteSpeed GUI, which cannot be set with native SQL Server. The format of this Plan ID would be similar to: 'CAA0AE9C-5374-4803-BC0A-DF2BEDBAD285'.
In versions 4.5x and 4.6x the LiteSpeed xp_slssqlmaint requires this plan id, whereas the native SQL Server xp_sqlmaint only requires the name of the database.
An enhancement request is open with LiteSpeed Development for the parameters of xp_slssqlmaint to be the same as the syntax of xp_sqlmaint.
