Archive and purge the Space Occupancy data (sn_wsd_wc_space_occupancy) table after every five days.
Vorbereitungen
The Archive rule Archive Space Occupancy table at the end of everyday runs every day to archive data from the Space Occupancy data (sn_wsd_wc_space_occupancy) table and archives it in the
Archived Space Occupancy Table (ar_sn_wsd_wc_space_occupancy). The Archive Destroy Rule Destroy Space Occupancy archived table after every 5 days purges data from Archived
Space Occupancy Table (ar_sn_wsd_wc_space_occupancy) after every five days.
Role required: admin
Prozedur
-
Navigate to .
-
Select and open the Archive Space Occupancy table at the end of everyday rule.
-
Select the Active check box.
-
In the Conditions field, change the archive filter conditions as required.
-
From the Related Links section, select Run Archive Now.
The archived data is stored in the Archived Space Occupancy (ar_sn_wsd_wc_space_occupancy) table.
-
Navigate to .
-
Select Archive space occupancy record.
All the deleted space occupancy data are stored in Show List under the Related Links section.
-
Navigate to .
-
Select Destroy Space Occupancy archived table after every 5 days.
-
In the Conditions field, set the archive duration condition as required.
-
From the Related Links section, select Run Archive Destroy Now to run the job.
The Space occupancy data table records are deleted permanently.