Database Maintenance Tasks
The RALS™ SYSTEM provides the ability to view the schedule for database maintenance tasks. In addition, a support user can manage the scheduling of database tasks, and execute the tasks ad-hoc. The default Database Maintenance System View displays the database maintenance task records.
Database Maintenance Task Execution
Database maintenance tasks are set up by default in the system, and are automatically executed at a pre-defined time. Database maintenance tasks cannot be cloned, and include the following tasks:
- Access Logs Purge
- Device Events Purge
- History Database Health Check
- History Purge
- HL7 Inbound Purge
- HL7InMsg Database Health Check
- LDAP Database Health Check
- LDAP Purge
- Legacy Results Purge
- Levey-Jennings Purge
- Linearity Purge
- LMS Database Health Check
- LMS Purge
- Logs Database Health Check
- Logs Purge
- MIG Database Health Check
- Persisted Grant Purge
- RALS Database Health Check
- Recertification Attempts Purge
- Reports Purge
- Results Purge
- SQL Maintenance Group 1 Task
- SQL Maintenance Group 2 Task
- SQL Maintenance Group 3 Task
- SQL Maintenance Group 5 Task
- SQL Maintenance Purge
Some of the purge tasks must be enabled in the Purge System Settings to ensure execution. See Purge System Settings for more information.
Database Health Check Task
The Database Health Check tasks periodically monitor and update database health statuses for the following databases:
- History
- HL7InMsg
- LDAP
- Logs
- LMS
- MIG
- RALS
Institution Access
Database maintenance tasks are a system-wide resource without any institution identity.
Fields
Database maintenance task fields are located in the following places in the RALS™ SYSTEM:
Data Table Fields
See Tasks - Data Table Fields for more information.
View or Edit Details Fields
When viewing database task details, the fields are defined as follows:
| Field | Notes |
|---|---|
| Schedule | |
| Automatic Execution | When checked, the task will automatically be executed |
| Due Time | Date and time task is scheduled to be executed |
| Repeats | Indicates how often a task schedule repeats |
| Interval | The time that the RALS™ SYSTEM will add to the due date or completion date after completion of a task to calculate the task’s next iteration’s due date |
| Repeats Based On | Execution of task based on due time or completion time |
| Notes | |
| Notes | Open text field that can be used at your discretion |
| Executions | See Task Executions for more information |