2 Archival Job Execution Flow
This topic provide information about the Archival Job Execution Flow.
Archival is the first step where eligible data aging more than the archival retention period is deleted from domain tables and moved to Archival tables. Archived data is purged in the 2nd step where eligible data aging more than the purge retention period is deleted and moved to purge tables. Finally eligible data aging more than the delete retention period is permanently deleted from purge tables.
Each of the job checks for the retention periods in the following order in single execution cycle.
ARCHIVAL_RETENTION_PERIOD
The system transfers records that have met the ARCHIVAL_RETENTION_PERIOD for the Task Flow from the domain schema tables to the archival schema tables.
PURGE_RETENTION_PERIOD
Checks for records that have reached PURGE_RETENTION_PERIOD for the Task Flow. All matching records are moved from archival schema tables to purge schema tables.
DELETE_RETENTION_PERIOD
Checks for records that have reached DELETE_RETENTION_PERIOD for the Task Flow. All matching records are deleted permanently from Purge schema tables.
Table 2-1 Execution Order
| Retention Type | Data Movement |
|---|---|
| ARCHIVAL_RETENTION_PERIOD | Move from Domain Schema Tables to Archival Schema Tables |
| PURGE_RETENTION_PERIOD | Move from Archival Schema Tables to Purge Schema Tables |
| DELETE_RETENTION_PERIOD | Delete from Purge Schema Tables |
You can modify these default retention periods.