EVALUATE_CALENDAR_STRING v16
Use the EVALUATE_CALENDAR_STRING
procedure to evaluate the repeat_interval
value specified when creating a schedule with the CREATE_SCHEDULE
procedure. The EVALUATE_CALENDAR_STRING
procedure returns the date and time that a specified schedule executes without actually scheduling the job.
The signature of the EVALUATE_CALENDAR_STRING
procedure is:
Parameters
calendar_string
calendar_string
is the calendar string that describes a repeat_interval
that's being evaluated.
start_date IN TIMESTAMP WITH TIME ZONE
start_date
is the date and time after which the repeat_interval
becomes valid.
return_date_after
Use the return_date_after
parameter to specify the date and time for EVALUATE_CALENDAR_STRING
to use as a starting date when evaluating the repeat_interval
.
For example, if you specify a return_date_after
value of 01-APR-13 09.00.00.000000
, EVALUATE_CALENDAR_STRING
returns the date and time of the first iteration of the schedule after April 1st, 2013.
next_run_date OUT TIMESTAMP WITH TIME ZONE
next_run_date
is an OUT
parameter that contains the first occurrence of the schedule after the date specified by the return_date_after
parameter.
Example
This example evaluates a calendar string and returns the first date and time that the schedule will execute after June 15, 2013:
Because June 15, 2013 is a Saturday, the schedule will execute on Monday, June 17, 2013 at 5:00 pm.
- On this page
- Parameters
- Example