How to use the calendar
In the forums, some questions are repeated over and over again. One of them is how to use or create a schedule. The Oracle documentation makes some attempt to explain the use of the calendar, but fails to use real examples. Here, we will see some examples that explain some of the real-life questions:
How to schedule on the first day of a month?
How to schedule only on Monday?
How to schedule on the first Monday of a month?
How to schedule on the first working day of a month?
How to schedule on the first working Monday of a month?
How to schedule on the nth Monday of a month?
How to schedule on the last working day of a month?
How to schedule in the first quarter of a year?
How to schedule on the first Monday of the first quarter of a year?
Tools
Before diving into the calendars, it would be good to know that there is a very useful tool in the database that can help debugging a calendar. This tool is the evaluate_calendar, which is found in the dbms_scheduler package. This procedure...
