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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AUTOTASK_ADMIN
DBMS_JOB
DBMS_SCHEDULER
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx