Oracle7 Server Distributed Systems Volume II: Replicated Data

Viewing Job Queue Information

The following data dictionary views display information about jobs in the job queue:

DBA_JOBS

USER_JOBS

DBA_JOBS_RUNNING

DBA_JOBS and USER_JOBS Views

The DBA_JOBS view provides information about all queued jobs in the database. The USER_JOBS view provides information about the jobs owned by you; that is, jobs for which you are the PRIV_USER.

Column Description
JOB Identifier of the job.
LOG_USER User logged in when the job was submitted.
For example, if user SCOTT calls a package that runs in the security domain of SYS, and this package starts a job, the LOG_USER would be SCOTT.
PRIV_USER User whose default privileges apply to this job.
For example, if user SCOTT calls a package that runs in the security domain of SYS, and this package starts a job, the PRIV_USER would be SYS.
SCHEMA_USER Default schema that parses the job.
For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.
LAST_DATE Last date that this job executed successfully, measured to the nearest day.
LAST_SEC Last date that this job executed successfully, measured to the nearest second.
THIS_DATE Date that the current execution of the job started, measured to the nearest day. Usually null if the job is not currently executing.
THIS_SEC Date that the current execution of the job started, measured to the nearest second. Usually null if the job is not currently executing.
NEXT_DATE Date that this job is next scheduled to be executed, measured to the nearest day.
NEXT_SEC Date that this job is next scheduled to be executed, measured to the nearest second.
TOTAL_TIME Total elapsed time spent by the system on this job, in seconds.
BROKEN "N" indicates that the job is not broken. "Y" indicates that the job is considered broken and will not be executed.
INTERVAL Date function that calculates the next time to execute the job.
FAILURES Number of times that the job was started and failed since it last successfully completed. After 16 failures, a job is marked as broken.
WHAT Job definition.
CURRENT_ SESSION_LABEL Trusted Oracle7 label of the current session, as seen by this job.
CLEARANCE_HI Highest level of clearance available to this job. Applies to Trusted Oracle7 only.
CLEARANCE_LO Lowest level of clearance available to this job. Applies to Trusted Oracle7 only.
NLS_ENV ALTER SESSION parameters that describe the NLS environment of this job.
MISC_ENV Other session parameters that apply to this job.

Table 13 - 27. DBA_JOBS and USER_JOBS Views

DBA_JOBS_RUNNING View

The DBA_JOBS_RUNNING view provides information about any jobs that are currently executing.

Column Description
SID Identifier of the session that is executing the job.
JOB Identifier of the job that is currently executing.
FAILURES Number of times the job was started and failed since it last successfully completed.
LAST_DATE Last date this job was successfully executed, measured to the nearest day.
LAST_SEC Last date this job was successfully executed, measured to the nearest second.
THIS_DATE Date the current execution of the job started, measured to the nearest day.
THIS_SEC Date the current execution of the job started, measured to the nearest second.

Table 13 - 28. DBA_JOBS_RUNNING View

Column	Description
JOB	Identifier of the job.
LOG_USER	User logged in when the job was submitted.
	For example, if user SCOTT calls a package that runs in the security domain of SYS, and this package starts a job, the LOG_USER would be SCOTT.
PRIV_USER	User whose default privileges apply to this job.
	For example, if user SCOTT calls a package that runs in the security domain of SYS, and this package starts a job, the PRIV_USER would be SYS.
SCHEMA_USER	Default schema that parses the job.
	For example, if the SCHEMA_USER is SCOTT and you submit the procedure HIRE_EMP as a job, Oracle looks for SCOTT.HIRE_EMP.
LAST_DATE	Last date that this job executed successfully, measured to the nearest day.
LAST_SEC	Last date that this job executed successfully, measured to the nearest second.
THIS_DATE	Date that the current execution of the job started, measured to the nearest day. Usually null if the job is not currently executing.
THIS_SEC	Date that the current execution of the job started, measured to the nearest second. Usually null if the job is not currently executing.
NEXT_DATE	Date that this job is next scheduled to be executed, measured to the nearest day.
NEXT_SEC	Date that this job is next scheduled to be executed, measured to the nearest second.
TOTAL_TIME	Total elapsed time spent by the system on this job, in seconds.
BROKEN	"N" indicates that the job is not broken. "Y" indicates that the job is considered broken and will not be executed.
INTERVAL	Date function that calculates the next time to execute the job.
FAILURES	Number of times that the job was started and failed since it last successfully completed. After 16 failures, a job is marked as broken.
WHAT	Job definition.
CURRENT_ SESSION_LABEL	Trusted Oracle7 label of the current session, as seen by this job.
CLEARANCE_HI	Highest level of clearance available to this job. Applies to Trusted Oracle7 only.
CLEARANCE_LO	Lowest level of clearance available to this job. Applies to Trusted Oracle7 only.
NLS_ENV	ALTER SESSION parameters that describe the NLS environment of this job.
MISC_ENV	Other session parameters that apply to this job.

Column	Description
SID	Identifier of the session that is executing the job.
JOB	Identifier of the job that is currently executing.
FAILURES	Number of times the job was started and failed since it last successfully completed.
LAST_DATE	Last date this job was successfully executed, measured to the nearest day.
LAST_SEC	Last date this job was successfully executed, measured to the nearest second.
THIS_DATE	Date the current execution of the job started, measured to the nearest day.
THIS_SEC	Date the current execution of the job started, measured to the nearest second.