How to execute slssqlmaint.exe directly from a command line?
slssqlmaint.exe can be directly executed at a command prompt. at <SQL Server Instance Path>\Binn\slssqlmaint.exe
For more information on the parameters, user can run "slssqlmaint.exe -?"
User can also create a maintenance plan in Quest Enterprise Console, the edit the job step to gather the parameter information he/she needed.
Example: Job step in the maintenance plan:
EXECUTE master.dbo.xp_slssqlmaint N'-PlanID 6AABCCD3-F626-4D6A-8368-D5ECE4FC5B9A -WriteHistory -BkUpMedia DISK -BkUpDB "E:\BACKUP\SQL2000" -DelBkUps 2DAYS -BkExt "BAK" -NOOPTOLR -Threads 3 -Throttle 100 -BufferCount 20 -MaxTransferSize 1048576 -CompressionLevel 1 -Priority 0 -Logging 2 -Affinity 0 '
would translate to the command line parameters:
slssqlmaint.exe -PlanID 6AABCCD3-F626-4D6A-8368-D5ECE4FC5B9A -WriteHistory -BkUpMedia DISK -BkUpDB "E:\BACKUP\SQL2000" -DelBkUps 2DAYS -BkExt "BAK" -NOOPTOLR -Threads 3 -Throttle 100 -BufferCount 20 -MaxTransferSize 1048576 -CompressionLevel 1 -Priority 0 -Logging 2 -Affinity 0
-or-
slssqlmaint.exe -PlanName "MYPLAN" -WriteHistory -BkUpMedia DISK -BkUpDB "E:\BACKUP\SQL2000" -DelBkUps 2DAYS -BkExt "BAK" -NOOPTOLR -Threads 3 -Throttle 100 -BufferCount 20 -MaxTransferSize 1048576 -CompressionLevel 1 -Priority 0 -Logging 2 -Affinity 0
-or-
execute@retval=msdb.dbo.sp_start_job @job_id='38F72341-443F-41A4-9DD7-9E02F4FF6CDA'
NOTE: Calling the Plan or Job from command line via slssqlmaint.exe is not supported. They are not documented thus they are not technically features. Using any of these undocumented features is unsupported and may potentially break in the future.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy