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 run the Maintain Process Tables task:

1. Click Application, then Jobs, and then Schedule Jobs.

2. From the Schedule Jobs page, then What type of job is this?, select Integration Maintenance Script.

3. To schedule an integration maintenance script to run now, see Scheduling Hourly Jobs .

   To schedule an integration maintenance script to run later, see Scheduling a Data Rule or Integration Definition to Run Later in the Job Scheduler.

4. From the Integration Maintenance Script page, click to the right of the Maintain Process Table task to schedule.

5. 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.

6. Click OK.