Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Overview and Examples of dbms_job Functions

 JOB WHAT                                              NEXT_DATE            INTERVAL
---- ------------------------------------------------- -------------------- ---------
   3 my_job_proc('DBMS_JOB.SUBMIT Example.');                22-JUN-2004 11:11:25 SYSDATE + 1/24 /* 1 Hour */
  99 my_job_proc('DBMS_JOB.ISUBMIT Example (WHAT).');        22-JUN-2004 12:24:13 SYSDATE + 1/12 /* 2 Hours */

2 rows selected.

The entire job definition can also be changed back using the change procedure.  If the what, next_date or interval parameters are NULL, the existing value is unchanged.

BEGIN

  DBMS_JOB.change (
    job       => 99,
    what      => 'my_job_proc(''DBMS_JOB.ISUBMIT Example.'');',
    next_date => TO_DATE('22-JUN-2004 10:11:20', 'DD-MON-YYYY HH24:MI:SS'),
    interval  => 'SYSDATE + 1/24 /* 1 Hour */');
  COMMIT;
END;
/

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