Database Integrity Checker Job

   Journey Manager (JM) The transaction engine for the platform.  |    System Manager / DevOps  |  23.04 This feature was introduced in 23.04

Manager provides the Database Integrity Checker job that periodically executes a Database Integrity Checker service to check the integrity of a database used by the server. This scheduled job runs weekly.

The Database Integrity check consists of the following validation rules:

1. Check tables for orphaned records based on entity relations
2. Check tables' indexes
3. Check services' default values
4. Check forms' delivery method configuration

For each validation rule, the Database Integrity Checker job generates a report, including the following information:

1. An entity, target entity and the number of invalid records in a table
2. An entity name and columns which we expect to have an index on

Then, the Database Integrity Checker job sends the report as an email to the Receive System Alerts - Database Integrity alert group. You need to assign this group to a user to receive the Database Integrity notifications.

The default Database Integrity Checker job configuration is shown below.

The Database Integrity Checker job adds an entry of the Database Integrity type to the Event Log. This allows you to find all Database Integrity issues easily.

The Event Log entry example is shown below:

Database Integrity Checker Job processed database indexes and found 1 invalid record(s):
Entity: submission Column(s): delivery_error_oid

You can also view the history of scheduled jobs and use Database Integrity Checker as a Job Name to narrow down your search, as shown below.

Next, learn how to manage scheduled jobs