Oracle PL/SQL for DBAs

Name

DBA_SCHEDULER_JOBS

Synopsis

This view shows the jobs defined in the database.

Column name	Description
OWNER	Owner of the job.
JOB_NAME	Name of the job.
CLIENT_ID	If the user specified the client identifier for the session while creating a job, it is recorded here. You can set the client identifier by calling DBMS_SESSION.SET_IDENTIFIER.
GLOBAL_UID	If the user is a global (or enterprise) user, the global user id is recorded here.
JOB_TYPE	The type of job; valid values are EXECUTABLE, PLSQL_BLOCK, and STORED_PROCEDURE.
JOB_ACTION	What the job does. If it is a PL/SQL code segment, then the entire segment is shown here. If it is an executable or a stored procedure, its name is recorded here.
START_DATE	Start time of the job in the TIMESTAMP datatype.
REPEAT_INTERVAL	Calendar string that specifies the schedule of the job (e.g., “FREQ=DAILY; BYHOUR=2”). (See the section "Calendar Strings" in Chapter 8.)
ENABLED	Whether the job is enabled (TRUE or FALSE).
STATE	Current state this job is in (e.g., SCHEDULED, RUNNING, SUCCEEDED, FAILED).
RUN_COUNT	Number of times this job has been run.
FAILURE_COUNT	Number of times this job has failed.
RETRY_COUNT	If the job failed, it is retried; this column shows how many times it has been retried.
LAST_START_DATE	Timestamp of the last time the job started.
LAST_RUN_DURATION	Duration of the last time the job ran.
NEXT_RUN_DATE	Next time the job is scheduled to run.
SYSTEM	Indicates whether a job is a system job (TRUE ...