Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+====== 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.
+<code plsql>
+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 timestamp with time zone;
+begin
+  for i in 1 .. number_of_dates
+  loop
+    dbms_scheduler.evaluate_calendar_string
+     (schedule, start_date, date_after, next_date);
+    dbms_output.put_line(to_char(next_date,
+                    'DY DD-MON-YYYY (DDD-IW) HH24:MI:SS TZH:TZM TZR'));
+    date_after := next_date;
+  end loop;
+end;
+/
+</code>