How Do I Make Sure That Scheduled Processes Run Smoothly and Quickly?

Scheduled processes do tasks that are too complex or time-consuming to do manually, for example importing data or updating many records.

Scheduled processes are available across Oracle Fusion Cloud Applications and based on functionality from Oracle Enterprise Scheduler. Because many processes can run at the same time, think of the queue of submissions as a high-speed interstate.

To ensure that the highway runs smoothly for your users, use the guidelines, and tips in this best practices document to help you with each stage of the scheduled processes life cycle:

  • Plan: Assess the processes that your users need to run, figure out when and how often to run them, and determine what custom jobs are needed, if any.
  • Implement: Configure any custom jobs, roll out your plan, and test.
  • Maintain: After users start running processes, make sure that everything keeps going without issues.
This life cycle isn’t linear or something that you would go through only once. For example, you might need to revisit the planning phase at any time to adjust your plan.
Note: These best practices are offered for your reference only. They’re not intended to represent the only approach, and might not produce the same results for everyone.

Before You Start

A prerequisite for understanding these best practices is to be familiar with scheduled processes and jobs. You should already know the concepts and tasks covered in Scheduled Processes and Enterprise Scheduler Job Definitions and Job Sets.

Additional Information

You can find information about many of the predefined processes:

For sample SQL queries that you can use to monitor your scheduled processes, see Sample SQL Queries for Monitoring Enterprise Scheduler Service (Doc ID 282161.1) .