Oracle | DBMS

Oracle DBMS_IJOB Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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