Oracle | DBMS

Oracle DBMS_IJOB Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose This package, and DBMS_JOB, are the are the only interfaces for manipulating jobs.

AUTHID CURRENT_USER

Dependencies

DBMS_DST	DBMS_JOB	DBMS_SNAPSHOT_KKXRCA
DBMS_INTERNAL_LOGSTDBY	DBMS_PRVTAQIP	DBMS_SNAPSHOT_UTL
DBMS_IREFRESH	DBMS_REFRESH	DUAL
DBMS_ISCHED	DBMS_SCHEDULER

Documented No

Exceptions

Error Code	Reason

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the IMP_FULL_DATABASE role.

Source {ORACLE_HOME}/rdbms/admin/prvthjob.plb
{ORACLE_HOME}/rdbms/admin/prvtjob.plb

Subprograms

BIS

Undocumented dbms_ijob.bis( flag IN NUMBER, val IN NUMBER, val2 IN BOOLEAN) RETURN NUMBER;

TBD

BIT

Undocumented dbms_ijob.bit( flag IN NUMBER, val IN NUMBER) RETURN BOOLEAN;

BEGIN

        IF dbms_ijob.bit(1,1) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      

      PL/SQL procedure successfully completed.

BROKEN

Undocumented dbms_ijob.broken( job IN BINARY_INTEGER, broken IN BOOLEAN, next_date IN DATE);

TBD

CHANGE_ENV

Undocumented dbms_ijob.change_env( job IN BINARY_INTEGER, luser IN VARCHAR2, puser IN VARCHAR2, cuser IN VARCHAR2, nlsenv IN VARCHAR2);

TBD

CHECK_DATAPUMP_AUTH

Undocumented dbms_ijob.check_datapump_auth(puser IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_ijob.check_datapump_auth(USER) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

CHECK_PRIVS

Undocumented dbms_ijob.check_privs(job IN BINARY_INTEGER);

TBD

CHECK_SCHEDULER_CONVERSION

Undocumented dbms_ijob.check_scheduler_conversion( reg_cb IN BOOLEAN, job IN BINARY_INTEGER, operation IN BINARY_INTEGER, instance IN BINARY_INTEGER, next_date IN TIMESTAMP WITH TIME ZONE) RETURN BOOLEAN;

TBD

ENABLED

Undocumented dbms_ijob.enabled RETURN BOOLEAN;

BEGIN

        IF dbms_ijob.enabled THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      

      PL/SQL procedure successfully completed.

FULL_EXPORT

Undocumented

Overload 1 dbms_ijob.full_export( job IN BINARY_INTEGER, mycall IN OUT VARCHAR2);

TBD

Overload 2 dbms_ijob.full_export( job IN BINARY_INTEGER, mycall IN OUT VARCHAR2, myinst IN OUT VARCHAR2);

TBD

INSTANCE

Undocumented dbms_ijob.instance( job IN BINARY_INTEGER, instance IN BINARY_INTEGER, force IN BOOLEAN);

TBD

INST_CHECK

Undocumented dbms_ijob.inst_check( instance IN NUMBER, force IN BOOLEAN);

exec dbms_ijob.inst_check(1, FALSE);

      

      PL/SQL procedure successfully completed.

INTERVAL

Resets a job's interval dbms_ijob.interval( job IN BINARY_INTEGER, interval IN VARCHAR2);

TBD

NEXT_DATE

Resets a job's next date dbms_ijob.next_date( job IN BINARY_INTEGER, next_date IN DATE);

TBD

PUID

Undocumented dbms_ijob.puid RETURN NUMBER;

SELECT dbms_ijob.puid

      FROM dual;

      

       PUID

      -----

          0

PUSER

Undocumented dbms_ijob.puser RETURN VARCHAR2;

SELECT dbms_ijob.puser

      FROM dual;

      

      PUSER

      ------

      SYS

REMOVE

Drops a job dbms_ijob.remove(job IN BINARY_INTEGER);

-- from $ORACLE_HOME/rdbms/admin/execocm.sql, reformatted for clarity

      BEGIN

       
      FOR r in job_cursor LOOP

         
      sys.dbms_ijob.remove(r.job);

         
      COMMIT;

       
      END LOOP;

      END;

      /

RUN

Runs a job dbms_ijob.run( job IN BINARY_INTEGER, force IN BOOLEAN);

TBD

SET_ENABLED

Undocumented dbms_ijob.set_enabled(enabled IN BOOLEAN);

exec dbms_ijob.set_enabled(TRUE);

      

      PL/SQL procedure successfully completed.

SET_JOB_AFFINITY

Undocumented dbms_ijob.set_job_affinity( mynum IN BINARY_INTEGER, instance IN BINARY_INTEGER);

TBD

SET_JOB_FOR_ISUBMIT

Undocumented dbms_ijob.set_job_for_isubmit( myjob IN BINARY_INTEGER, dummy IN BINARY_INTEGE);

TBD

SUBMIT

Submit a Job

Overload 1 dbms_ijob.dbms_ijob.submit( job IN BINARY_INTEGER, luser IN VARCHAR2, puser IN VARCHAR2, cuser IN VARCHAR2, next_date IN DATE, interval IN VARCHAR2, broken IN BOOLEAN, what IN VARCHAR2, nlsenv IN VARCHAR2, env IN RAW);

-- example from $ORACLE_HOME/rdbms/admin/a18.sql, reformatted for clarity

      

      BEGIN

        sys.dbms_ijob.submit(job => job_map.job, luser => job_map.powner,

                             puser => job_map.powner, cuser => job_map.powner,

                             next_date => job_map.next_date, interval => job_map.interval#,

                             broken => broken, what => job_map.what,

                             nlsenv => job_map.nlsenv, env => '');

        COMMIT;

      EXCEPTION

        WHEN dup_val_on_index THEN

          NULL;

        WHEN OTHERS THEN

          dbms_output.put_line('WARNING: DBMS_JOB job '||job_map.job||' resubmit failed');

      END;

Overload 2 dbms_ijob.dbms_ijob.submit( job IN BINARY_INTEGER, luser IN VARCHAR2, puser IN VARCHAR2, cuser IN VARCHAR2, next_date IN DATE, interval IN VARCHAR2, broken IN BOOLEAN, what IN VARCHAR2, cs_lab IN MLSLABEL, cl_hi IN MLSLABEL, cl_lo IN MLSLABEL, nlsenv IN VARCHAR2, env IN RAW);

TBD

TOGGLE

Undocumented dbms_ijob.toggle( flag IN NUMBER, val IN NUMBER) RETURN NUMBER;

TBD

UPDATE_METADATA

Undocumented dbms_ijob.update_metadata( job IN BINARY_INTEGER, flag IN NUMBER);

TBD

WHAT

Resets a Job's description (WHAT) dbms_ijob.what( job IN BINARY_INTEGER, what IN VARCHAR2);

TBD