Disallow Starting Certain Unscheduled (Ad Hoc) Jobs During the Daily Maintenance Process
To prevent automatic backup from failing due to certain jobs running during the daily maintenance process, certain unscheduled (ad hoc) jobs are now disallowed from starting while the daily maintenance process is running.
In 23.03, certain scheduled jobs (listed below) were prevented from starting during the daily maintenance process. Now these same jobs are prevented from starting on an ad hoc basis. This means that if you attempt to start a job during the daily maintenance process using the Run Now option on the Schedule Job 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 then select Run Now, the system will prevent the job from starting and you'll see an error message.
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
Business Benefit: Prevents automatic backup failures due to certain jobs starting during daily maintenance.
Key Resources
- Getting Started with Oracle Enterprise Performance Management Cloud for Administrators