To set Job Manager options
Use this option... |
To... |
Default |
---|---|---|
Scheduler Page |
Set the following options. |
— |
Show server time |
Display the local time and the time difference between the desktop and the server at the top of the Calendar tab for each server. |
Selected |
Show recurring executions as one item |
Simplify the display by showing jobs that run multiple times as one job. |
Selected |
Show jobs that run continuously during the day on top of the schedule |
Display the continuously running jobs at the top of the schedule. |
— |
Task List Page |
Set the following options. |
— |
Show steps |
Display each job step on the Job List tab in an expanding row in the list or in a separate pane at the bottom of the window. |
Under each row of a job |
Show history |
Display job history on the Job List tab in a separate pane at the bottom of the window. On Demand—Display history only after clicking Show History. (Selected.) If cleared, history displays automatically when you select a job. |
Cleared |
Advanced |
Click Advanced to set the following options. |
— |
Maximum number of threads |
Specify the maximum number of total concurrent threads to use on target instances to run the jobs. |
3 |
Maximum appointments |
Specify the maximum number of appointments that can display on the Calendar tab. If the number of appointments exceeds this value, appointments may display incorrectly. |
25 |
Show disabled jobs |
Display the jobs that have been disabled. |
Selected |
Refresh job status after start/stop |
Refresh the job status automatically after the job is either started or stopped. |
Selected |
Auto refresh windows tasks every: |
Specify the auto refresh rate in seconds for windows tasks. |
— |
Tip: Click Advanced | Known Applications to add new or change existing masks and icons. A mask is a pattern used to group
To set the Log Reader options
Review the following for additional information:
Use this option... |
To... |
Default |
---|---|---|
Check log file changes every |
Check the log file for changes every so many seconds. |
Selected |
Show uncommitted transactions |
List all the transactions that are not committed. |
Selected |
Reconstruct DDL commands |
Select this option to display both DML and DDL commands |
Selected |
Export all details of the log |
Export all details of the log file. TIP: Select this option to get a full report. |
Not Selected |
Online log reading timeout |
Set the amount of time the log is read before a timeout is reached. |
300 seconds |
Maximum BLOB size |
Set the maximum Binary Large Object (Blob) Data size. |
8000 bytes |
Reconstruction |
Select one or both of the following:
|
Selected |
Search Depth |
Select whether to read the entire log file or only a set number of records in the log file. The options are:
|
100000 |
LiteSpeed requires the following privileges and grants:
To replicate job, maintenance plans and log shipping information
On the local repository server, do one of the following:
- Execute dbo.xp_replicate_job_statistics against the master database.
- From the command line, change the directory until you are in the directory containing the LiteSpeed command-line utilities (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine) and run ActivityManager.exe -GatherJobStats.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy