Chapter 3 - Time-Based Job Scheduling
||Oracle Tips by Burleson
Complex Date Rules
for Job Execution
The same result could be achieved by running a different schedule in
each environment, but it serves to illustrate the point.
It should now be obvious that there is an
almost limitless combination of possible calendar string and PL/SQL
expression variations. The only way to become really confident with
repeat intervals is to try as many variations as possible. The test
procedures presented in this chapter will allow this to be done
without having to actually schedule jobs, which in turn will save
lots of time.
In this chapter, a number of areas both
directly and indirectly related to repeat intervals of scheduled
jobs have been covered. The topics include:
The use of the DATE datatype,
including modification of dates using literals and date functions.
The use of the TIMESTAMP datatype,
including the use of timestamp functions.
The use of the INTERVAL datatype, the
interval literal syntax and interval functions.
The calendar syntax in Oracle10g.
Complex date rules for job
execution in jobs scheduled using the dbms_job and
The next chapter will investigate a number of
techniques that can be implemented to make job scheduling more
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.