Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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> --