Select Routine Schedule Day and Time
You can now select the day and time to run a routine on a recurring schedule. Each schedule period has options relevant for that period. For example, you can include and exclude weekends from the daily period or you can select one or more days from the weekly period. Existing routines will continue to run at the day and time selected when they were created. If required, you can edit the trigger to change the day and time.
Often a process might need to run at the beginning of the day, end of day, or first or last day of the month. This feature expands routines to accommodate the scheduling of these processes.
Steps to Enable
You don't need to do anything to enable this feature.
Tips And Considerations
To run the routine on the last day of the month, select the option for "Last day". For monthly and yearly scheduling options, when you select a day of the month, for example the 31st, the routine will run on the 31st day of the month. If the month doesn't have a 31st day, the routine won't run for that specific month.
Key Resources
For information about Routines, see https://docs.oracle.com/en/cloud/saas/sales/fadsi/overview-of-routines.html
Access Requirements
To use Routines, you must have the Manage Routines privilege (ZCA_MANAGE_ROUTINES). This privilege is available to the following roles by default:
- Application Implementation Consultant
- Sales Administrator
- Customer Relationship Management Application Administrator
Note: If you're working with custom objects, you will also require the ORA_CRM_EXTN_ROLE role.