cal_eval.sql

来自「Oracle PLSQL for DBAs 源代码」· SQL 代码 · 共 23 行

DECLARE
   l_start_date    TIMESTAMP;
   l_next_date     TIMESTAMP;
   l_return_date   TIMESTAMP;
BEGIN
   l_start_date := TRUNC (SYSTIMESTAMP);
   l_return_date := l_start_date;
   FOR ctr IN 1 .. 10
   LOOP
      dbms_scheduler.evaluate_calendar_string
                       ('FREQ=MONTHLY;INTERVAL=2',
                        l_start_date,
                        l_return_date,
                        l_next_date
                       );
      DBMS_OUTPUT.put_line (   'Next Run on: '
                            || TO_CHAR (l_next_date, 'mm/dd/yyyy hh24:mi:ss')
                           );
      l_return_date := l_next_date;
   END LOOP;
END;
/