Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

Oracle Tips by Burleson

Jobs

BEGIN
  -- Run job synchronously.
  DBMS_SCHEDULER.run_job (
    job_name            => 'test_full_job_definition',
    use_current_session => FALSE);

  -- Stop jobs.
  DBMS_SCHEDULER.stop_job (
    job_name => 'test_full_job_definition,
test_prog_sched_job_definition');
END;
/

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:

• old_job - The name of the job whose attribute will be duplicated to create the new job.
   

• new_job - The name of the duplicate job to be created.

An example of its usage might be as follows:

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA