Skip to content

Data Cleanup Task Schedulers

Four different system defined Database Task Schedulers have been configured in IFS Cloud to cleanup Workflow related historical data from the database.

You could modify the schedule options and data retention period default values in each scheduler. But it is highly recommended to keep the default values without changing them since some of the historical data needs to keep as per the data retention policy.

Note:

Changing the default configuration, might leads to losing the data that requires for auditing.

Cleanup Workflow Process Instances

This scheduler is used to clear the old Workflow execution data from Workflow engine tables. It runs daily at 1.00 AM and clear the Workflow execution data older than the given month. Default is 3 months and can be reduced up to 1 month.

Cleanup Workflow Observation Data

This scheduler is used to clear old Workflow Observation data. It runs daily at 1.00 AM and clear the Workflow Observation data older than the given hours. Default is 1 hour.

Cleanup Asynchronous Workflow Data

This scheduler is used to clear the asynchronous Workflow execution data from the BPA_ASYNC_SYS_TAB table. It runs daily at 1.00 AM and clear the asynchronous Workflow execution data (STATUS = 'DONE' or (STATUS = 'IP' and RETRY_COUNT >= 3) ) older than the given retention period. Default is 1 month (30 days) and can be reduced up to 1 day.

Schedule parameters highlighted above can be customized as per the requirement.

Parameter Name Description
MONTHS_OLD_ Data retention period in months. Default is 1 month. Here, 1 month is equal to 30 days.
DAYS_OLD_ Data retention period in days. Default is 0. Both MONTHS_OLD_ and DAYS_OLD_ parameters can be specified same time, and the retention period will be calculated based on the aggregation of these two values accordingly.
BATCH_SIZE_ The data cleanup job is executed in batches, with the cleared data committed at the end of each batch. This parameter determines the batch size. Default is 10,000.
TIME_OUT_SEC_ Time out period in second. Default is 300 (5 minutes). This parameter determines the maximum duration the scheduler should run. If the scheduler job reaches this timeout period, it is automatically stopped.
SHRINK_SPACE_ Specify whether you want to shrink the table and rebuild its indexes. Default is ‘NO’.

Cleanup Workflow Troubleshooting Data

This scheduler is used to clear the old Workflow Troubleshooting data. It runs daily at 1.00 AM and clear the Workflow Troubleshooting data older than the given days and hours. Default is 2 days and 0 hour.