Table of Contents Previous Next


3 Built-In Packages : 3.15 DBMS_SCHEDULER : 3.15.1 Using Calendar Syntax to Specify a Repeating Interval

The CREATE_JOB and CREATE_SCHEDULE procedures use Oracle-styled calendar syntax to define the interval with which a job or schedule is repeated. You should provide the scheduling information in the repeat_interval parameter of each procedure.
repeat_interval is a value (or series of values) that define the interval between the executions of the scheduled job. Each value is composed of a token, followed by an equal sign, followed by the unit (or units) on which the schedule will execute. Multiple token values must be separated by a semi-colon (;).
FREQ=predefined_interval
Where predefined_interval is one of the following: YEARLY, MONTHLY, WEEKLY, DAILY, HOURLY, MINUTELY. The SECONDLY keyword is not supported.
BYMONTH=month(, month)...
Where month is the three-letter abbreviation of the month name: JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
BYMONTH=month(, month)...
Where month is the numeric value representing the month: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
BYMONTHDAY=day_of_month
Where day_of_month is a value from 1 through 31
BYDAY=weekday
Where weekday is a three-letter abbreviation or single-digit value representing the day of the week.
BYDATE=date(, date)...
Where date is YYYYMMDD.
YYYY is a four-digit year representation of the year,
MM is a two-digit representation of the month,
and DD is a two-digit day representation of the day.
BYDATE=date(, date)...
Where date is MMDD.
MM is a two-digit representation of the month,
and DD is a two-digit day representation of the day
Where hour is a value from 0 through 23.
BYMINUTE=minute
Where minute is a value from 0 through 59.

3 Built-In Packages : 3.15 DBMS_SCHEDULER : 3.15.1 Using Calendar Syntax to Specify a Repeating Interval

Table of Contents Previous Next