How to set up reporting and logging in a LiteSpeed Maintenance Plan?
Please see video below:
1. Start up the LiteSpeed Console, choose Maintenance Plan from the left Panel.
2. Choose a registered SQL Server, Right click on the Maintenance Plan and click "Edit Maintenance Plan"
3. From the Maintenance Menu Bar, Choose the last Button ¨Reporting and Logging".
4. In the Reporting and Logging control, check "Write a text file report in directory" and put a valid path
5. check "Log Extended information" and click OK to save.
To execute the plan manually, right click on the Plan and choose Execute Maintenance Plan.
Check the subplan and click OK to run it
After it has finished, you can see the report generated in the directory you previously stated.
Debug Logging—Logs LiteSpeed maintenance plan utility activity.
When a subplan is executed, the Maintenance Plan engine saves the archived <plan_name>_<subplan_name>[<GUID>].zip file in the default output directory if under Reporting & Logging, the Debug Logging is set to Verbose.
The location of the verbose engine log is determined by the path in the HKEY_LOCAL_MACHINE\SOFTWARE\Imceda\SQLLiteSpeed\Engine\ErrorLogPath (The default is: C:\Documents and Settings\All Users\Application Data\Quest Software\LiteSpeed)
