Maintain Process Tables

This process maintains the following execution tables:

  • AIF_PROCESSES

  • AIF_PROCESS_DETAILS

  • AIF_PROCESS_LOGS

  • AIF_PROCESS_PARAMETERS

  • AIF_PROCESS_PERIODS

  • AIF_PROCESS_STEPS

  • AIF_BAL_RULE_LOADS

  • AIF_BAL_RULE_LOAD_PARAMS

  • AIF_BATCH_JOBS

  • AIF_BATCH_LOAD_AUDIT

  • AIF_TEMP

To run the Maintain Process Tables script:

  1. Complete the steps for scheduling a maintenance script.

    For more information, see Scheduling Maintenance Scripts in the Job Scheduler.

  2. From the Schedule Job page, select Maintain Process Folder.

  3. From the Maintain Process Tables page, and then from Days to keep records, specify the number of days to keep records in the execution tables.