How to create a LiteSpeed maintenance plan using xp_slssqlmaint with an additional native job step, such as copy or delete.
N/A
1. From the LiteSpeed Enterprise Console, create LiteSpeed maintenance plan with a backup task. Save.
2. Access the job created as part of the maintenance plan. Open the second tab (Steps).
3. Click the 'New' button. Add the t-sql for the native task in the Command window. Name the Step 'Step 2'.
4. Open Step 1 and 'Advanced' tab. Update the 'On success action' select "Goto Step 2"
See attached for screenshots/example. Also see Solution SOL18296