Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle



  Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 3 - Time-Based Job Scheduling

Complex Date Rules for Job Execution

The previous section used the test_calendar_string.sql procedure to display the run schedule expected for a specific calendar string.  Before any comparisons between the possible scheduling methods can be done, a way to test the PL/SQL expressions that are used to schedule jobs using dates and timestamps is needed.  The test_date_string procedure listed below is similar to the test_calendar_string procedure, but it displays run dates defined by interval strings that might be used when scheduling jobs via the dbms_job package.


-- *************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties.  Use at your own risk.
-- To license this script for a commercial purpose,
-- contact
-- *************************************************
set serveroutput on;
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
  p_interval    IN  VARCHAR2,
  p_iterations  IN  NUMBER DEFAULT 5)
  l_interval           VARCHAR2(1000) := p_interval;
  l_start_date         DATE := TO_DATE('01-JAN-2004 03:04:32',
                                       'DD-MON-YYYY HH24:MI:SS');

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.