 |
|
Oracle Tips by Burleson |
Chapter 3 - Time-Based Job Scheduling
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.
Conclusion
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
dbms_scheduler packages.
The next chapter will investigate a number of
techniques that can be implemented to make job scheduling more
robust.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
