20 System Maintenance Tasks

You can run system processes to maintain and clean up all runtime artifacts, such as the Process tables, Staging tables or inbox/outbox folders. Often the tables and folders contain vast amounts of data, which you may no longer need. With the System Maintenance Tasks feature, you can purge standard tables and folder by scheduling system processes and executing them in the EPM Platform Job Scheduler.

System Maintenance Tasks include:

• Partition Data Load Staging Tables

• Deleting an Integration

• Export Setup Table Data

• List Table Rowcount

• Maintain Application Folder

• Maintain Data Table by Location
• Maintain Data Table by Application

• Maintain Process Tables

• Maintain Setup Data

• Migrating Schedules to EPM Platform Job Scheduler
• Purge All Imported Data

• Upgrade Custom Applications

• Reallocate Tablespace

• Reset Environment

System Maintenance Tasks can be accessed directly from Data Integration to perform system maintenance locally.

You can also select System Maintenance Task parameters using the Job Scheduler. For more information, see Scheduling Maintenance Scripts in the Job Scheduler.