Chapter 1 -
Overview of Oracle Job Scheduling
||Oracle Tips by Burleson
Migrating from dbms_job to
-- New scheduler.
job_action => 'BEGIN NULL; /* Do Nothing */ END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'SYSTIMESTAMP + 1 /* 1 Day */');
By comparing these examples, it is noted that
conversion of basic jobs is quite simple, involving the following
Define a meaningful job_name for the
Assign a job_action of PLSQL_BLOCK.
Use the what value from the old job
as the job_action value in the new job.
Use SYSTIMESTAMP for the start_date
Use the interval value from the old
job as the repeat_interval value in the new job, making
sure the result of the expression is a TIMESTAMP not a DATE.
Once this conversion has been completed for all
jobs, there is freedom from using the old scheduler, so the
job_queue_processes parameter can now be set to zero.
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.