Database Reference
In-Depth Information
BEGIN sys.dbms_ijob.run(1); END;
*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 406
ORA-06512: at line 1
SQL> ORADEBUG SETMYPID
Statement processed.
SQL> ORADEBUG TRACEFILE_NAME
/opt/oracle/obase/admin/TEN/udump/ten1_ora_19365.trc
SQL> !tail -4 /opt/oracle/obase/admin/TEN/udump/ten1_ora_19365.trc
ORA-12012: error on auto execute of job 1
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: '+DG/ten/datafile/sysaux.261.628550067'
ORA-06512: at "PERFSTAT.STATSPACK", line 5376
Source Code Depot
Table 18-2 lists this chapter's source files and their functionality.
Table 18-2.
DBMS_IJOB Source Code Depot
File Name
Functionality
dbms_ijob_full_export.sql
Generates PL/SQL code to recreate a job by retrieving its meta-
data from
DBA_JOBS
(or rather
SYS.JOB$
).
dbms_job_metadata.sql
This script creates a table for implementing custom logging of
DBMS_JOB
jobs in a database table. The job definition uses PL/SQL
job metadata variables to record the job number and the next
scheduled run date. If an exception occurs, the job catches it,
records the error in the logging table, and marks itself as broken.
