Skip to content

Database Jobs#

At any given time there are several jobs running in the Online and ODS database instances of any Critical Manufacturing installation. Here is a list of the jobs deployed during the installation procedure and that can be monitored and controlled via SQL Server Management Studio.

Info

For more information on SQL Server Management Studio, see the Monitoring page.

Online Database Jobs#

Job Name Recurrence Description
Data Replication Every minute Replicates data from the Online database to the ODS database
Delete History Tables Every 5 hours Removes historical data from the Online database once present in the ODS database
Execute Enqueued Commands Every 5 minutes Executes the enqueued commands against the Online database. This mechanism is mainly used for long running DDL or DML scripts during the installation or upgrade process
Execute ODS Enqueued Commands Every 5 minutes Executes the enqueued commands against the ODS database. This mechanism is mainly used for long running DDL or DML scripts during the installation or upgrade process
Purge Entity Types Daily Permanently removes terminated entity instances (and associated data) from the Online database for which the History Retention Time has been reached
Reseed Identity columns Daily Seeds all the identity columns in the Online database to the correct values. Ensures data integrity and database stability by avoiding large gaps in the identity columns. Useful for ODS database table partitioning
Terminate Expired Chart Data Points Daily Removes chart data points for which the retention time has been reached
Terminate Integration Entries Daily Removes integration entries for which the retention time has been reached

Table: Online Database Jobs

ODS Database Jobs#

Job Name Recurrence Description
Data Warehouse Every 5 minutes Aggregates data from the ODS database to the DWH database and performs the SSAS Cube process
DWH Partitioning Management Every 6 hours Maintains the DWH partitioning mechanism. Adds the necessary data files and modifies the partition schemes and functions accordingly 1
Execute Enqueued Commands in ODS Every 5 minutes Executes the enqueued commands against the ODS database. This mechanism is mainly used for long running DDL or DML scripts during the installation or upgrade process. Works in tandem with the Online job
Export Terminated Materials XML Daily Exports all the entities related to a terminated Material Entity to various XML files so that it can be recovered after data has been removed from the original tables. To execute this job, the ad hoc distributed queries ⧉ option must be enabled in SQL Server. 1
Main Table Partitioning Daily Maintains the ODS main tables partitioning mechanism. Adds the necessary data files and modifies the partition schemes and functions accordingly. This jobs also synchronizes purged entities between Online and ODS databases 2
ManagePartitions Daily Maintains the ODS history tables partitioning mechanism. Adds the necessary data files and modifies the partition schemes and functions accordingly 2

Table: ODS Database Jobs

Note