Oracle PL/SQL/System Tables Views/USER JOBS

SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS

   <source lang="sql">

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

</source>
   
  

user_jobs table

   <source lang="sql">

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

</source>
   
  

Viewing Your Own Jobs

   <source lang="sql">

SQL> SQL> SELECT JOB,WHAT,NEXT_DATE, NEXT_SEC, FAILURES,BROKEN

 2  from USER_JOBS

</source>