Maintain Process Tables

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 schedule the script to run now, see Scheduling a Job to Run Now.

To schedule the script to run later, see Scheduling a Job to Run Later.

When scheduling the Maintain Process Tables script, from Days to keep records, specify the number of days to keep records in the execution tables.