Setting the Daily Maintenance Process Start Time

Understand how to determine and set the most convenient time to start the hour-long daily maintenance process.

A business process instance requires one hour every day to perform routine maintenance. Service Administrators can select (and change) the most convenient time to start the hour-long daily maintenance process.

For information about daily maintenance operations and scheduling the maintenance start time for an environment, see Managing Daily Maintenance in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Note:

There is a system setting called Export EPM Cloud Smart List textual data during daily maintenance for incremental data import that, depending on if this setting is enabled, could impact the duration of the export. For more information and for recommendations about using this setting, see the following topics:

To prevent automatic backup from failing due to certain jobs running during daily maintenance, EPM Cloud disallows certain jobs from starting while the daily maintenance process is running.

The following jobs are prevented from starting during daily maintenance:

  • Import Data

  • Import Metadata

  • Export Data

  • Export Metadata

  • Refresh Database

  • Clear Cube

  • Restructure Cube

  • Compact Outline

  • Merge Data Slices

  • Optimize Aggregation

These jobs are prevented from starting whether they are jobs that are scheduled or jobs that are started on an ad hoc (unscheduled) basis.

For unscheduled jobs, this means that if you attempt to start a job during the daily maintenance process using the Run Now option on the Schedule Jobs page or if you submit a job from the listing page of your job definitions, the job will be prevented from starting. If the system prevents an ad hoc job from starting, an error message will display.

For example, if you view the jobs listed on the Clear Cube page while daily maintenance is running and then you click Actions and then Submit, an error message will display and the job will not start. Similarly, if you create a Clear Cube job on the Schedule Job page during daily maintenance and select Run Now, the system will prevent the job from starting and you'll see an error message.

If the system prevents a job from starting, the reason will be stated in the Job Details. If you've enabled email notifications for the Job Console, you'll receive an email notification when a job does not start. If you have a job that is scheduled to start during the daily maintenance process, it is recommended that you reschedule your job to start outside of the daily maintenance window. See Scheduling Jobs.