LiteSpeed for SQL Server 8.9.8 - Security and Compliance Guide

Introduction LiteSpeed Security Features LiteSpeed for SQL Server and FISMA Compliance Customer Measures

LiteSpeed_SyncJobs_Stats

This stored procedure synchronize LiteSpeed Jobs, Maintenance plans or Log Shipping activity and information from LiteSpeed Local to the Central database. Using the procedure the date and time can be defined from which to which date and time the data will be synchronized from the Jobs, Maintenance plans or Log Shipping

NOTE: Run the LiteSpeed_SyncJobs_Stats procedure against the desired Local database that is installed on the SQL Server from which you want to synchronize data to the Central database.LiteSpeed databases (Local and Central) by default are named LiteSpeedLocal and LiteSpeedCentral.

NOTE: Custom database—You can use the LiteSpeed Instance Configuration wizard (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration) to choose where to store the repository data if is not set by default names.

This topic covers:

Syntax
Arguments
Examples

Syntax

exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats @startDate = '20210517 04:05'
{ @startDate = 'date time' }

exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats @startDate = '20210517 04:05', @endDate = '20210516 04:04'
{ @startDate = 'date time' | ( @endDate = 'date time' )}

Arguments

This stored procedure accepts the following arguments:

Argument	Description
@startDate	Deletes data older than the date and time specified. The argument accepts the following format: YYYYMMDD HH:MM:SS where YYYY—4-digit year MM—2-digit month DD—2-digit day of the month HH—2-digit hour using the local 24-hour clock MM—2-digit minute SS—2-digit second
@endDate	Deletes data until the date and time specified. The argument accepts the following format: YYYYMMDD HH:MM:SS where YYYY—4-digit year MM—2-digit month DD—2-digit day of the month HH—2-digit hour using the local 24-hour clock MM—2-digit minute SS—2-digit second

Argument

Description

@startDate

Deletes data older than the date and time specified. The argument accepts the following format:

YYYYMMDD HH:MM:SS

where

YYYY—4-digit year
MM—2-digit month
DD—2-digit day of the month
HH—2-digit hour using the local 24-hour clock
MM—2-digit minute
SS—2-digit second

@endDate

Deletes data until the date and time specified. The argument accepts the following format:

YYYYMMDD HH:MM:SS

where

YYYY—4-digit year
MM—2-digit month
DD—2-digit day of the month
HH—2-digit hour using the local 24-hour clock
MM—2-digit minute
SS—2-digit second

Examples

Synchronize the following data from the beginning until 08/08/2021 08:00 from the Local to the Central repository:
- LiteSpeed Jobs, Maintenance plans or Log Shipping activity
- The data from the desired activity will be synchronized from the Local to the Central repository
exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats @startDate = '20210808 08:00'
Synchronize the following data from the 04/04/2020 07:15 until 08/08/2021 08:00 from the Local to the Central repository:
- LiteSpeed Jobs, Maintenance plans or Log Shipping activity
- The data from the desired activity will be synchronized from the Local to the Central repository
exec LiteSpeedLocal.dbo.LiteSpeed_SyncJobs_Stats
@startDate = '20210808 08:00',
@endDate = '20210404 07:15'

In a graphical user interface, right-clicking on a server reveals the option Sync Local and Central Activities.

This option opens the Configure LiteSpeed Local and Central Synchronization dialog, where a user selects Server instances and the option to Sync Jobs, Maintenance plans or Log Shipping activity between local and central repositories. The date range for data synchronization can be selected from the calendar view.