Archive Schedule table

archId

IDType

This field is the unique Archive identifier.

archEnable

boolType

This field indicates whether to enable or disable archiving.

svrName

sysnameType

This field is the name of the computer running SQL Server.

dbName

sysnameType

This field is the name of the database to archive.

archDevice

devnameType

This field is the name of the destination Archive device.

archCutoff

cutoffType

This field specifies the last date of records to be archived. The format is YY:MM:DD.

archTime

GMTtime

The field is the last date of records that was archived.

archOffset

GMTtime

This field is the offset to the local time zone that was in effect when archTime occurred.

delCutoff

cutoffType

This field specifies the last date of records to be deleted. The format is YY:MM:DD.

delTime

GMTtime

This field is the last time of records that was archived.

delOffset

GMToffset

This field is the offset to the local time zone that was in effect when delTime occurred.

partitioningConfigured

boolType

This field is specific to tables configured for partitioning and which contain a Coordinated Universal Time (UTC) field (for example, the collect table in the TimeSeries database).

The partitioningConfigured field is set to False by default.

The timestamp of data qualified for the Archive operation is based on the time zone of the machine running the Archive data server.

Examples:

The Archive data server is in the MST time zone. When partitioningConfigured is set to False, an archive file contains rows timestamped with the UTC of 2021-12-01 07:00:00.0000000 to 2021-12-01 06:59:00.0000000.

The Archive data server is in the MST time zone. When partitioningConfigured is set to True, an archive file contains rows timestamped with the UTC of 2021-12-01 00:00:00.0000000 to 2021-12-01 23:59:00.0000000.