LiteSpeed for SQL Server 8.9 - User Guide

Configure 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.

Related Topic

About Managing Jobs

Set 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

Related Topics

Analyze Transaction Logs

Read Transaction Logs

Configure Replication and Retention Options for Repositories

LiteSpeed requires the following privileges and grants:

Push Statistics to Central Repository

There are two options for replicating statistics to the central repository. The first option replicates the LiteSpeed activity. The second option only replicates job status, maintenance plans and log shipping information.

If you did not select to populate the central repository automatically or via a scheduled job during Instance Configuration, you can manually force a replication at any time by calling the ActivityManager.exe file from the command line or using the extended stored procedures.

NOTE: The xp_replicate_activity_statistics command is designed for sync changes between the local and central repositories. LiteSpeed does not contain information about the native backup history because it is a SQL Server native tool. You must use the [LiteSpeedLocal]..[LiteSpeed_ImportNativeHistory] procedure to import the native backup history first into the local repository.

To replicate database and LiteSpeed activity information

On the local repository server, do one of the following:

• 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.

Related Topics

About Collecting Statistics in Repositories

Register Central Repositories