1. Implementation Guide
  2. Batch Orchestration
  3. Initial Batch Setup
  4. Maintenance Cycles

Maintenance Cycles

The AIF DATA schedule also includes a standalone maintenance batch flow called RI_MAINTENANCE_ADHOC. You need to enable and schedule this process to run nightly, sometime prior to the main nightly batch.

  1. From Batch Administration, go into the AIF DATA schedule Standalone tab and locate the RI_MAINTENANCE_ADHOC flow. If the jobs are disabled, then enable them now.

  2. Go into Schedule Administration and add a new schedule for the flow, enable it, and schedule it to run once every day. It is recommended to start it several hours prior to the actual nightly batch; for example, it can run starting at 8 pm local time if your nightly batch starts at 2 am the following morning. These processes should not impact normal user activity in the applications and are safe to run even if users are still logged in.

  3. From Batch Monitoring, restart the AIF DATA schedule to apply the changes.

The maintenance cycle is responsible for creating table partitions, repairing unusable indexes, purging old log files, and purging certain records relating to deleted items and locations. All of these activities are necessary to ensure the data warehouse operates efficiently over time as data continues to accumulate in the system. These jobs are kept outside of the nightly batch flow because there is a chance they will need several hours to run in some instances, such as when a large number of new partitions need to be created at the start of a fiscal quarter or a particularly large number of log files have to be purged.