V10.6 and later
Overview
The database holds a lot of data for internal use only, that occupies a lot of space in the DB and impedes the system performance. For example, the UACT tables where data becomes useless after the instance is closed.
The scheduler jobs perform routine cleanup tasks in the DB, thus optimizing the DB storage and enhancing the system performance.
DB cleanup scheduler jobs
Following are the DB cleanup scheduler system jobs:
| Job | Description |
|---|---|
| Job Run History Cleanup | Removes tail items from the job run history log. |
| Maintenance Log Cleanup | Removes tail items from the system maintenance log. |
| Portal User History Cleanup | Removes tail items from the Portal user history. |
| Backend Activities Data Cleanup | Removes data from the Service and Error Handler activities tables of completed instances that are moved to the closed tables. |
| SSB Cleanup | Removes inactive SQL Service Broker (SSB) queues. |
| DocumentSet Change Tracker Cleaner | Removes track changes from the DocumentSet. |
| Rule Based Workflow Starter Log Cleaner
|
Removes logs of the rule based workflow starter. |
Configure DB cleanup system jobs
In the Administration site, go to Administration>Global Settings>Jobs Management.
The system jobs are there by default in the state “disabled”. The system admin needs to enable them.
Job
- Name: The name of the job.
- Description: A description of the job.
Command
Set the command parameters.
- The command parameters are different in each job.
- It’s recommended to use the default scheduling, but the system admin may change that according to need.
Advanced
Set the advanced parameters.
- It’s recommended to use the default scheduling, but the system admin may change that according to need.
