ALL_JOBS

ALL_JOBS describes all jobs in the database that are accessible to the current user.

See Also:

Oracle Database Administrator's Guide

Related Views

DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the current user.

Column	Datatype	NULL	Description
`JOB`	`NUMBER`	`NOT NULL`	Identifier of job. Neither import/export nor repeated executions change this value.
`LOG_USER`	`VARCHAR2(30)`	`NOT NULL`	Login user when the job was submitted
`PRIV_USER`	`VARCHAR2(30)`	`NOT NULL`	User whose default privileges apply to this job
`SCHEMA_USER`	`VARCHAR2(30)`	`NOT NULL`	Default schema used to parse the job For example, if the `SCHEMA_USER` is `SCOTT` and you submit the procedure `HIRE_EMP` as a job, the Oracle Database looks for `SCOTT`.`HIRE_EMP`
`LAST_DATE`	`DATE`		Date on which this job last successfully executed
`LAST_SEC`	`VARCHAR2(8)`		Same as `LAST_DATE`. This is when the last successful execution started.
`THIS_DATE`	`DATE`		Date that this job started executing (usually null if not executing)
`THIS_SEC`	`VARCHAR2(8)`		Same as `THIS_DATE`. This is when the last successful execution started.
`NEXT_DATE`	`DATE`	`NOT NULL`	Date that this job will next be executed
`NEXT_SEC`	`VARCHAR2(8)`		Same as `NEXT_DATE`. This is when the last successful execution started.
`TOTAL_TIME`	`NUMBER`		Total wall clock time spent by the system on this job, in seconds
`BROKEN`	`VARCHAR2(1)`		`Y`: no attempt is made to run this job `N`: an attempt is made to run this job
`INTERVAL`	`VARCHAR2(200)`	`NOT NULL`	A date function, evaluated at the start of execution, becomes next `NEXT_DATE`
`FAILURES`	`NUMBER`		Number of times the job has started and failed since its last success
`WHAT`	`VARCHAR2(4000)`		Body of the anonymous PL/SQL block that the job executes
`NLS_ENV`	`VARCHAR2(4000)`		Session parameters describing the NLS environment of the job
`MISC_ENV`	`RAW(32)`		Other session parameters that apply to this job
`INSTANCE`	`NUMBER`		ID of the instance that can execute or is executing the job. The default is 0.