About Scheduling Routines
Understanding scheduling can help you determine the optimal recurrence period when creating routines. Routines run on a recurring schedule, defined as hourly, daily, weekly, monthly, and yearly.
To schedule and run routines, you must have the appropriate privileges and job roles. For example:
- You must first already have access to Routines via the privilege, ZCA_MANAGE_ROUTINES.
- The ZCA_SCHEDULE_ROUTINE_APPID privilege must be assigned to the desired role. If you are working with custom objects, you will also require the ORA_CRM_EXTN_ROLE role.
During the trigger step of the Create Routine work flow, you can select the Schedule routine with elevated access check box if you want to schedule the routine to run across all data for an object. Once a routine is created with elevated access, the access can't be changed.
Routines are scheduled through the Enterprise Scheduling Service (ESS) process and are included as part of your daily application processing.
- Divides each day into 24 available time slots
- Assigns a maximum of 5 routines to start for each time slot
- Sets a maximum limit of 10,000 rows a routine can process per time slot.
Once a routine is assigned a day and time slot, it continues to run on that specific day and time. The application schedules to run routines between days 1 to 28 of the month.
Here's a table that lists the maximum number of routines in a day for each schedule period and the maximum number of routines that can be run for a schedule period.
Schedule Time Periods | Total Daily Time Slots | Total Time Slots per Period |
---|---|---|
Hourly | 24 | Hourly routines are limited to 250 records per run. |
Daily | 80 | Schedule up to 80 routines daily. |
Weekly | 20 | Schedule up to 140 routines weekly. |
Monthly | 15 | Schedule up to 420 routines monthly. |
Yearly | 5 | Schedule up to 1,680 routines yearly. |