Guest User

Untitled

a guest
Apr 26th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. DECLARE
  2. next_run_date TIMESTAMP;
  3. BEGIN
  4. FOR i IN 1..10 LOOP
  5. DBMS_SCHEDULER.EVALUATE_CALENDAR_STRING('FREQ=HOURLY;BYHOUR=06,07,08,09,10,11,12,13,14,15,16,17,18,19,20,21,22,23;BYMINUTE=0;BYSECOND=0;BYDAY=Mon', NULL, next_run_date, next_run_date);
  6. DBMS_OUTPUT.PUT_LINE ( next_run_date );
  7. END LOOP;
  8. END;
  9.  
  10.  
  11. 2018-04-30 06:00:00.000
  12. 2018-04-30 07:00:00.000
  13. 2018-04-30 08:00:00.000
  14. 2018-04-30 09:00:00.000
  15. 2018-04-30 10:00:00.000
  16. 2018-04-30 11:00:00.000
  17. 2018-04-30 12:00:00.000
  18. 2018-04-30 13:00:00.000
  19. 2018-04-30 14:00:00.000
  20. 2018-04-30 15:00:00.000
Add Comment
Please, Sign In to add comment