https://www.chakravir.net/ 2026-06-08T00:49:10+00:00 https://www.chakravir.net/ https://www.chakravir.net/lib/tpl/dokuwiki/images/favicon.ico text/html 2008-05-14T15:54:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.chakravir.net/doku.php?id=code:scheduler:showing_dates_in_a_schedule&rev=1210805649&do=diff Showing dates in a Schedule This code fragment can be used to see what dates a particular schedule or repeat interval will generate. It can be used to test schedules without having to schedule a job. create or replace procedure print_schedule_dates ( schedule in varchar2, start_date in timestamp with time zone default dbms_scheduler.stime(), number_of_dates in pls_integer default 10 ) is date_after timestamp with time zone := start_date - interval '1' second; next_date timestam…