 |
|
Oracle Tips by Burleson |
Chapter 1 -
Overview of Oracle Job Scheduling
Migrating from dbms_job to
dbms_scheduler
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
system.
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.
VARIABLE
l_job NUMBER;
BEGIN
DBMS_JOB.submit (
job
=> :l_job,
what
=> 'BEGIN NULL; /* Do Nothing */ END;',
next_date
=> SYSDATE,
interval
=> 'SYSDATE + 1 /* 1 Day */');
COMMIT;
END;
/
PRINT l_job
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
