|
 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Data Dictionary
Views Related to dbms_job
As with the majority of dba_% views, there are equivalent
all_% and user_% views. The all_% views display
all objects the user owns or has privileges on, while the user_%
views display only those objects the user owns. For the remainder
of this topic, the focus will only be on the dba_% views as
these views display the full list of objects, regardless of
ownership or privileges.
For detailed examples of the proper usage of
views, refer to Chapter 5 Monitoring Oracle Job Execution.
dba_jobs
The dba_jobs view is used to display all
information related to the database jobs. This view is described
below.
SQL> describe dba_jobs
Name
Null? Type
----------------------------- -------- ----------------
JOB NOT NULL NUMBER
LOG_USER
NOT NULL VARCHAR2(30)
PRIV_USER
NOT NULL VARCHAR2(30)
SCHEMA_USER
NOT NULL VARCHAR2(30)
LAST_DATE
DATE
LAST_SEC
VARCHAR2(8)
THIS_DATE
DATE
THIS_SEC
VARCHAR2(8)
NEXT_DATE
NOT NULL DATE
NEXT_SEC
VARCHAR2(8)
TOTAL_TIME
NUMBER
BROKEN VARCHAR2(1)
INTERVAL NOT NULL VARCHAR2(200)
FAILURES NUMBER
WHAT VARCHAR2(4000)
NLS_ENV
VARCHAR2(4000)
|
