Purge Archived Event Log Records

Explanation

This activity is used to purge/delete archived event log records, that are no longer needed for any purpose. The records will be permanently removed from the system and will not be possible to restore.

When purging data, it is possible to define 4 parameters as the selection criteria for what to purge/delete. Note: The dates are based on when the event log records where archived, not when they were created.

• Entity which means that only events related to that specific entity will be purged e.g. JtTask would only purge events for work tasks. This value is optional, and if left blank, all event log records for the specified time period will be permanently deleted.
• Event which works in combination with the entity, allowing you to only delete event records for a specific event. This value is optional, and if left blank, all events log records for the specified time period and entity will be purged.
• From Offset (Days) starts from today and allows you to enter a negative value, used to decide from which date to purge. You could for instance enter "-300", to delete all records created 300 days ago, up until the To Offset specified. This value is optional, and if left blank, all event log records will be deleted, up until the "To Date".
• To Offset (Days) starts from today and allows you to enter a negative value. You could for instance enter "-100" to delete all records created up until a 100 days ago. If the From Offset is left blank, all event log records for the defined criteria up until 100 days ago will be deleted.

This activity can be performed as a scheduled task or executed online as a one-time action.

It is possible to schedule purging to run on a Daily, Weekly or Monthly basis, a specific date, an interval (e.g. every 12 hours) or to use a Custom Expression (e.g. DBMS_SCHEDULER syntax like "FREQ=YEARLY;BYMONTH=JAN,JUL;BYMONTHDAY=21", which means every year on January 21 and July 21.)

Let's assume that it's 2023-08-01 (August 1, 2023) and there is a schedule set up to purge Entity SrvRequest (Request-related event log records) with a From Offset of -100 and a To Offset of -10. Event log records related to Requests, archived between 2023-04-23 (April 23, 2023) and 2023-07-22 (July 22, 2023) would be deleted. When this scheduled job would run the next day, event log records related to Requests, archived between 2023-04-24 (April 24, 2023) and 2023-07-23 (July 23, 2023) would be deleted, and so on.

It is important to note that the purging will only delete archived event log records and that the action is irreversible.

Prerequisites

• Archived Event Log records must exist for the given criteria.

System Effects

• All Archived Event Log records up until a given date, will be deleted/purged from the Archived Event log history.

Pages

Archived Event Logs
Purge Event Log page

Activity Diagrams

Handle Event Log