-
Title
Is -JOBP parameter required? What is -jobP parameter? -
Description
LiteSpeed Maintenance Plan includes the -jobP parameter; what does it represent?
Example:
EXECUTE master.dbo.xp_slssqlmaint N'-PlanID 08D0A457-6205-479A-9238-913E88DAA2C -WriteHistory -BkUpMedia DISK -BkUpDB -UseDefDir -BkExt "BAK" -NOOPTOLR -Threads 3 -Throttle 100 -BufferCount 20 -MaxTransferSize 1048576 -CompressionLevel 1 -jobp "hgXmKPoCrkHYyW6vd7Vi4A==" -Priority 0 -Logging 0 -Affinity 0 -CryptLevel 6 ' -
Resolution
The -jobp and @encryptionkey are the same value. They are both the encryption key.
The t-sql created by the LiteSpeed Maintenance Plan:
EXECUTE master.dbo.xp_slssqlmaint N'-PlanID 08D0A457-6205-479A-9238-913E88DAAA2C -WriteHistory -BkUpMedia DISK -BkUpDB -UseDefDir -BkExt "BAK" -NOOPTOLR -Threads 3 -Throttle 100 -BufferCount 20 -MaxTransferSize 1048576 -CompressionLevel 1 -jobp "hgXmKPoCrkHYyW6vd7Vi4A==" -Priority 0 -Logging 0 -Affinity 0 -CryptLevel 6 '
The script that is created by the Backup Database Wizard:
exec @rc = master.dbo.xp_backup_database @database = N'test1', @GUID = N'CABCC124-5E69-4CA4-98FB-F0B5061E73DC', @filename = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\test1200803281412LiteSpeed_Full.BKP', @backupname = N'test1 backup', @desc = N'Backup of test1 on 2008-03-28 14:12:27', @encryptionkey = N'pass', @cryptlevel = 6, @comment = '', @with = N'SKIP', @with = N'STATS = 10'
The -jobp and @encryptionkey are the same value, they are both the encryption key.