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






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

1.Viewing Your Own Jobs
2.SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS