8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: test_calendar_string.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/10g/test_calendar_string.sql -- Author : Tim Hall -- Description : Displays the schedule associated with a calendar string. -- Requirements : Access to the DBMS_SCHEDULER package. -- Call Syntax : @test_calendar_string (frequency) (interations) -- @test_calendar_string 'freq=hourly; byminute=0,30; bysecond=0;' 5 -- Last Modified: 27/07/2005 -- ----------------------------------------------------------------------------------- SET SERVEROUTPUT ON; SET VERIFY OFF ALTER SESSION SET nls_timestamp_format = 'DD-MON-YYYY HH24:MI:SS'; DECLARE l_calendar_string VARCHAR2(100) := '&1'; l_iterations NUMBER := &2; l_start_date TIMESTAMP := TO_TIMESTAMP('01-JAN-2004 03:04:32', 'DD-MON-YYYY HH24:MI:SS'); l_return_date_after TIMESTAMP := l_start_date; l_next_run_date TIMESTAMP; BEGIN FOR i IN 1 .. l_iterations LOOP DBMS_SCHEDULER.evaluate_calendar_string( calendar_string => l_calendar_string, start_date => l_start_date, return_date_after => l_return_date_after, next_run_date => l_next_run_date); DBMS_OUTPUT.put_line('Next Run Date: ' || l_next_run_date); l_return_date_after := l_next_run_date; END LOOP; END; /