user_jobs table : USER_JOBS « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_JOBS

user_jobs table

 
SQL>
SQL>
SQL> desc user_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)
 MISC_ENV                                                       RAW(32)
 INSTANCE                                                       NUMBER

SQL>
SQL> select job, what
  2    from user_jobs
  3   where broken = 'Y';

no rows selected

SQL>
SQL> --

 

Related examples in the same category