PARAMETER

MEANING

byhour

Specifies the hour or hours of the day with valid values from zero to 23.  Negative numbers result in a backwards count.

-- Run on the first hour of every day.

SQL> exec test_calendar_string('freq=daily; byhour=1');
Next Run Date: 02-JAN-2004 01:04:32
Next Run Date: 03-JAN-2004 01:04:32
Next Run Date: 04-JAN-2004 01:04:32
Next Run Date: 05-JAN-2004 01:04:32
Next Run Date: 06-JAN-2004 01:04:32

PL/SQL procedure successfully completed.

byminute

Specifies the minute or minutes of the hour with valid values from zero to 59.

-- Run on the first minute of every hour.

SQL> exec test_calendar_string('freq=hourly; byminute=1');
Next Run Date: 01-JAN-2004 04:01:32
Next Run Date: 01-JAN-2004 05:01:32
Next Run Date: 01-JAN-2004 06:01:32
Next Run Date: 01-JAN-2004 07:01:32
Next Run Date: 01-JAN-2004 08:01:32

PL/SQL procedure successfully completed.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA