Calendaring expression or PL/SQL block

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

Calendaring expression or PL/SQL block

Rating:

When more complicated and sophisticated capabilities are required for the repeat_interval attribute while creating a schedule then PL/SQL block is preferably used. The PL/SQL block must evaluate to a timestamp or a date. An example of using PL/SQL block to specify the repeat_interval is given below:

BEGIN
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'scott.my_schedule',
start_date => '15-JUL-04 01.00.00 AM Europe/Warsaw',
repeat_interval => 'SYSTIMESTAMP + INTERVAL '30' MINUTE',
end_date => '15-SEP-04 01.00.00 AM Europe/Warsaw',
comments => 'Using PL/SQL');
END;
/

The schedule will run for the first time on July 15 and then every 30 minutes until September 15.

Rating: