如何檢視資料庫中的job任務

在資料庫的日常維護中會使用job來定期完成某些任務如何檢視已經定義的job呢我們可以通過如下語句

sql> col interval format a10

sql> col log_user format a10

sql> col segment_user format a10

sql> col what format a40

sql> select job,instance,interval,next_date,

  2  next_sec,failures,broken,log_user,priv_user,schema_user

  3  ,total_time,what

  4  from dba_jobs;

   job   instance interval   next_date      next_sec           failures b log_user   priv_user                      schema_user                    total_time what                                                                                                                                     

---------- ---------- ---------- -------------- ---------------- ---------- - ---------- ------------------------------ ------------------------------ ---------- ----------------------------------------

27   1 wk_job.nex 20-2月 -1101:00:00   n sys  wksys wksys 0 wksys.wk_job.invoke(22,25);

                      t_time('dy0701')                 

26 1 wk_job.nex 16-2月 -11 14:00:00   0 n sys wksys   wksys 123 wksys.wk_job.invoke(22,24);   

                      t_time('hh0001')                                               

4001 0 sysdate +  16-2月 -11 18:10:57  0 n sys flows_030000   flows_030000  4 wwv_flow_cache.purge_sessions(p_purge_se8/24ss_older_then_hrs => 24);           

4002  0 sysdate +  16-2月 -11 13:51:19   0 n sys  flows_030000    flows_030000  24 wwv_flow_mail.push_queue(wwv_flow_platfo10/1440 rm.get_preference('smtp_host_address'),wwv_flow_platform.get_preference('smtp_host_port'));             

29   0 sysdate +  16-2月 -11 13:50:25  0 n sysman     sysman   sysman 94 emd_maintenance.execute_em_dbms_job_proc1/24 *s();                          

                      60)

sql> desc dba_jobs

 名稱                  描述

 -------------------- -------------------------------------------------------------------------------

 job                   job 的辨別符                                                     

 log_user             job 的擁有者                                             

 priv_user            誰擁有預設權限來應用這個job                                            

 schema_user                                                     

 last_date             job 上一次成功執行的時間                                                      

 last_sec             job 上一次成功執行的那次job 開始執行的時間                                         

 this_date            job 這次現在開始執行的時間 如沒有者為null          

 this_sec             同上                                                    

 next_date             job 下一次執行的時間                                      

 next_sec              同上

 total_time          程序運作的時間總量其值與系統中同時運作的程序數有關 機關 秒

 broken               如果為y 表示終止job即使再次到達job的執行時間時job也執行。

 interval             一個時間函數

 failures              job 失敗的次數

 what                  對job的描述

 nls_env               alter session parameters describing the nls environment of the job

 misc_env              a versioned raw maintained by the kernel

 instance              instance number restricted to run the job

sql> select job,what from dba_jobs;

       job what                                                                     

---------- ----------------------------------------                                    

        27 wksys.wk_job.invoke(22,25);                                               

        26 wksys.wk_job.invoke(22,24);                                               

      4001 wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24);

      4002 wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('smtp_host_address'),                            wwv_flow_platform.get_preference('smtp_host_port'));

        29 emd_maintenance.execute_em_dbms_job_procs();