10g里 DBMS_SCHEDULER 和 DBMS_JOB 区别

布满荆棘的人生 2022-08-24 05:26 177阅读 0赞

**10g里 DBMS\_SCHEDULER 和 DBMS\_JOB 区别**

<table style="TABLE-LAYOUT: fixed"> 
 <tbody> 
 <tr> 
 <td> 
 <div> 
 <div> 
 从10g开始，DBMS_SCHEDULER 逐步会替换掉 DBMS_JOB，下面是它们的区别及其替换的理由。 
 DBMS_JOB has been around forever, and now it is deprecated. Although DBMS_JOB still exists in 10g and 11g, but only for backward compatibility. No new features are being added to dbms_job and you will likely quickly run into its limitations. Oracle recommends the use of DBMS_SCHEDULER in releases 10g and up. DBMS_SCHEDULER is a much more robust package and fully-featured than DBMS_JOB. To use the DBMS_SCHEDULER package a user must be granted the CREATE JOB privilege. 
 DBMS_SCHEDULER includes the following features that DBMS_JOB does not have : 
 <ul> 
 <li>logging of job runs (job history) </li> 
 <li>simple but powerful scheduling syntax (similar to but more powerful than cron syntax) </li> 
 <li>running of jobs outside of the database on the operating system </li> 
 <li>resource management between different classes of jobs </li> 
 <li>use of job arguments including passing of objects into stored procedures </li> 
 <li>privilege-based security model for jobs </li> 
 <li>naming of jobs and comments in jobs </li> 
 <li>stored, reusable schedules </li> 
 </ul> 
 Features in releases after 10g Release 1 include : 
 <ul> 
 <li>dependencies between job units (10gR2 and up) </li> 
 <li>scheduling based on financial calendars and fiscal quarters (10gR2 and up) </li> 
 <li>event based jobs which run when an event is received (10gR2 and up) </li> 
 <li>running of jobs on remote machines (11gR1 and up) </li> 
 <li>e-mail notifications on job events of interest (10gR2 and up) </li> 
 <li>starting a job based on arrival of a file (10gR2 and up) </li> 
 </ul> 
 Here simple comparison for the codes : 
 <ul> 
 <li>Old using DBMS_JOB scheduler.VARIABLE l_job NUMBER; BEGIN DBMS_JOB.submit ( job =&gt; :l_job, what =&gt; ‘BEGIN NULL; /* code to execute*/ END;’, next_date =&gt; SYSDATE, interval =&gt; ‘SYSDATE + 1 /* 1 Day */’);COMMIT; END; / PRINT l_job </li> 
 <li>New with DBMS_SCHEDULER scheduler.BEGIN DBMS_SCHEDULER.create_job ( job_name =&gt; ‘dummy_job’, job_type =&gt; ‘PLSQL_BLOCK’, job_action =&gt; ‘BEGIN NULL; /* code to execute */ END;’, start_date =&gt; SYSTIMESTAMP, repeat_interval =&gt; ‘SYSTIMESTAMP + 1 /* 1 Day */’); END; / </li> 
 </ul> 
 After replace DBMS_JOB with DBMS_SCHEDULER for all jobs successful, the job_queue_processes parameter can now be set to zero. 
 SQL&gt; alter system set job_queue_processes=0; 
 There is also a forum dedicated to questions about dbms_scheduler here : 
 &nbsp;<a title="Oracle Forums" href="http://forums.oracle.com/forums/forum.jspa?forumID=193" rel="nofollow">http://forums.oracle.com/forums/forum.jspa?forumID=193 </a> &nbsp;<a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:388480262167" rel="nofollow">http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:388480262167</a> 
 </div> 
 </div></td> 
 </tr> 
 </tbody> 
</table>