Oracle Scheduler - Oracle 10g/11g Data and Database Management Utilities - page 204

Combined schedule = schedule_list

[";" include_clause]

[";" exclude_clause]

[";" intersect_clause]

BYMONTH {[JAN, FEB, ... DEC] |
[1, 2, ... 12]}

BYWEEKNO {1,2, ... 53}

BYYEARDAY {[minus] 1,2, ... 366}

YEARLY
MONTHLY
WEEKLY
DAILY
HOURLY
MINUTELY
SECONDLY

BYDATE{Date [YYYY]MMDD
|[offset | span]}

Interval Num { 1 ..999}

BYMONTHDAY {[minus] 1,2, ...31}

Interval

BYDAY
{[minus][weekDayNum]MON, TUE, ...SUN}
=1 ..53(yearly freq.)
=1 ..5(monthly freq.)

Frequency clause

BYHOUR {0, 1, ..23}
BYMINUTE {0, 1, ...59}
BYSECOND {0, 1, ...59}

timing

Repeat Interval = Frequency Clause [ ; interval ] [ ; timing]

Frequency clause : This can be either a predefined frequency or a user defined
frequency. The predefined frequencies are YEARLY, MONTHLY, WEEKLY,
DAILY, HOURLY, MINUTELY, and SECONDLY. A task whose schedule is
programmed with the clause FREQ=MINUTELY will wait for the next minute to
start being scheduled.

In this example a task is programmed to run each minute, so the frequency clause is
declared MINUTELY :

sys.dbms_scheduler.create_job(
job_name => '"OSCHEDULER"."TEST_MINUTELY"',
job_type => 'STORED_PROCEDURE',
job_action => 'OSCHEDULER.INS_JOB_LOG_ENTRY',
repeat_interval => 'FREQ=MINUTELY',
start_date => systimestamp at time zone 'America/Chicago',
job_class => 'DEFAULT_JOB_CLASS',
comments => 'Test Minutely Scheduling',
auto_drop => FALSE,
number_of_arguments => 1,
enabled => FALSE);