Oracle PL/SQL/System Tables Views/USER JOBS

SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS

 
SQL> --
SQL> SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS;
       JOB
----------
WHAT
--------------------------------------------------
LAST_SEC
--------
INTERVAL
--------------------------------------------------
        21
HELLO;
18:12:52
SYSDATE + (1/(24*60*60))
        22
HELLO;
18:12:52
SYSDATE + (1/(24*60*60))
        41
HELLO;
SYSDATE + (1/(24*60*60))
        42
HELLO;
SYSDATE + (1/(24*60*60))

4 rows selected.
SQL>
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> --

Viewing Your Own Jobs

 
SQL>
SQL> SELECT JOB,WHAT,NEXT_DATE, NEXT_SEC, FAILURES,BROKEN
  2  from USER_JOBS