Oracle - Calendar Parameters, calender string, value, BY, clause

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 3 - Time-Based Job Scheduling

Calendar Syntax in Oracle10g

PARAMETER

MEANING

bysecond

Specifies the second or seconds of the minute with valid values from zero to 59. Negative numbers result in a backwards count.

-- Run on the first second of every minute.

SQL> exec test_calendar_string('freq=minutely; bysecond=1');
Next Run Date: 01-JAN-2004 03:05:01
Next Run Date: 01-JAN-2004 03:06:01
Next Run Date: 01-JAN-2004 03:07:01
Next Run Date: 01-JAN-2004 03:08:01
Next Run Date: 01-JAN-2004 03:09:01

PL/SQL procedure successfully completed.

Table 3.10 – Calendar parameters and their meanings

The following points contain general guidance information for the use of calendar syntax during scheduling:

The calendar string must contain a frequency as the first clause. All other clauses are optional and can be placed in any order.
Each clause can only be present once and must be separated by a semi-colon.
The calendar strings are not case sensitive and white spaces between clauses are allowed.
Where a BY clause contains a list of values, the order of the list is not important.

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

http://www.rampant-books.com/book_2005_1_scheduling.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books