Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
-- Run job synchronously.
use_current_session => FALSE);
-- Stop jobs.
job_name => 'test_full_job_definition,
A new job can be created as a replica of an
existing job using the copy_job procedure. The new job is
created in the disabled state, with the old job remaining unchanged.
PROCEDURE copy_job (
old_job IN VARCHAR2,
new_job IN VARCHAR2)
The parameters associated with this procedure
and their usage are as follows:
An example of its usage might be as follows:
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA