Configure Job Manager Options

Job Manager Options

To set Job Manager options

1. Click the Application Button and select Options.
2. Select the Job Manager tab. Review the following for additional information:

   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 jobs or tasks with similar names and display the appropriate icon for them. Masks are stored locally.

Set Log Reader Options

Log Reader Options

To set the Log Reader options

1. Select the Application Button and select Options (Keyboard: ALT+F+O).
2. Select the Log Reader tab.

3. 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 10 seconds
   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: Request full database backup file if needed - When reading an online or offline log, the Log Reader might need to refer to the full-backup file for the database to reconstruct old log records. Select this option to enable the use of the full-backup file. Enclose Undo/Redo scripts in a transaction - Use this option to turn on or off transactions for undo/redo scripts. NOTE: You need to turn off transactions to undo or redo in-memory objects.	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: Read entire log file - Select this option to read the entire log file. Read approximately - Select this option to set the number of records to read. NOTE: The minimum number of records to read is 100,000. The Log Reader stores temp data in %temp%/Quest Software where %temp% is the first path found of: the path specified by the TMP environment variable, the path specified by the TEMP environment variable, the path specified by the USERPROFILE environment variable, the Windows temp directory.	100000

Configure Replication and Retention Options for Repositories

Privilege and Grant Requirements

LiteSpeed requires the following privileges and grants:

Push Statistics to Central Repository

• Execute dbo.xp_replicate_activity_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.

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.

•  Previous
• Viewing Topics 21 - 24 of 117
• Next