Chapter 1 -
Overview of Oracle Job Scheduling
||Oracle Tips by Burleson
Migrating from dbms_job to
Since Oracle 10g supports both the dbms_job and
dbms_scheduler packages, it may be wise to continue running
existing jobs until familiar with all the features of the new
scheduler. This “do nothing” approach is only a temporary option as
the original scheduler is retained for backwards compatibility
only. There is no guarantee that it will be present in future
versions of the database, so take steps now to future-proof the
When deciding to start converting jobs, the
easiest option is to use the new scheduler the same way the old one
was used. In previous sections, a simple example of each scheduling
mechanism was presented.
-- Old scheduler.
=> 'BEGIN NULL; /* Do Nothing */ END;',
=> 'SYSDATE + 1 /* 1 Day */');
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.