数据库的问题

Question

oracle10g数据库的jobs名称如下：
JOB_NAME
--------------------------------------------------------------------------------
MERGE_DATA
GATHER_STATS
请问怎么查看jobs的具体定义方式？

Answer 1

select * from user_jobs

Answer 2

select * from user_jobs;
select * from all_jobs;
select * from dba_jobs;
--其中比较重要的是：interval和what字段

Answer 3

-- 顶一下！scott@SZTYORA> L
  1* select job, what from user_jobs
scott@SZTYORA> /       JOB WHAT
---------- ------------------------------
        21 GET_DB_INFO_PROC;
        22 GET_DB_INFO_PROC;
        41 GET_DB_INFO_PROC2;scott@SZTYORA> desc user_jobs;
 名称                                                                                      是否为空? 类型
 ----------------------------------------------------------------------------------------- -------- ----------------------------------
 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

Answer 4

select * from user_jobs;
select * from all_jobs;
select * from dba_jobs;