Skip to main content

Work with Purging 

Some tables in the AutomationEdge database accumulate a large amount of data over time. To maintain optimal system performance, these records should be periodically purged.

Purging enables the creation of a Purge Policy and Purge Schedule to periodically clean up these database tables. This process reduces database and disk space usage, thereby enhancing the performance of the AutomationEdge system.

Purging Configuration

Policy

Purging option is available for the following data tables:

  • Workflow Requests

  • Audit Logs

  • User Session History

  • Notification History

    A System Administrator has the permissions to set up Purge Policy and Purge Schedule.

    A Tenant Administrator can only edit the Purge Policy at the Tenant level setup by a System Administrator. A Tenant Administrator cannot set up or edit a Purge Schedule.

    To create a purge policy:

  1. Navigate to **Purging **→ Purging Configuration

  2. Click Edit.Details page appears.

  3. In the details page, provide the desired purge duration in months for each of the four tables. Also, set notification details.

    IMG_256

Figure 72: Purge policy details 

  1. Click Save. The details appear in the Purging Configuration page.

    IMG_256

Figure 73: Purge policy 

Schedule 

A System Administrator can create a purge schedule, whereas a Admin can only view a purge schedule created by the System Administrator. 

Create purge schedule

Use the following steps to create a purge schedule.

  1. Navigate to Purging. The Purging Configuration page appears. 

  2. On the page, click the Schedule tab, and then click Add. Purge Schedule configuration page appears. 

    IMG_256

Figure 74: Purge Schedule Configuration 

  1. The schedule fields appears.

    Enter the following field details:

|-----------------|----------------------------------------------------|

FieldsDescription
CriteriaSelect the criteria from the list. Available
options are:
Day of Month
Day of Week
---------------------------------------------------------------------
Start Time*Select the purge start time in hours and / or
minutes.
---------------------------------------------------------------------
If the selected
criteria is Day
of Month, then
the following
fields are
available:
---------------------------------------------------------------------
Day of Month*Select the day of the month to schedule the purge.
---------------------------------------------------------------------
If the selected
criteria is Day
of Week, then
the following
fields are
available:
---------------------------------------------------------------------
Day of Week*Select the day of the week when you want to
schedule the purge.
---------------------------------------------------------------------
Week of theSelect the week of the month when you want to
Month*schedule the purge.
---------------------------------------------------------------------

*: indicates a mandatory field.

  1. Click Save. The purge schedule details are saved.

    IMG_256

|-----------|----------------------------------------------------------| | - | - Click Edit and modify the schedule details.  | | | |

- Click Delete to delete the schedule. 

: Figure 75: Purge Schedule Created