dbms_schedulervsdbms_job-创新互联

Although dbms_job still exists in 10gand 11g, Oracle recommends the use of dbms_scheduler in releases 10g and up. Nonew features are being added to dbms_job and you will likely quickly run intoits limitations.

dbms_scheduler is more robust andfully-featured than dbms_job and includes the following features that dbms_job doesnot have :

dbms_scheduler功能比dbms_jobs更加健全，推荐使用dbms_scheduler；以下比较来自google，并不代表全部观点。

·        logging of job runs (job history)

·        simple but powerful scheduling syntax (similar to butmore powerful than cron syntax)

·        running of jobs outside of the database on the operatingsystem

·        resource management between different classes of jobs

·        use of job arguments including passing of objects intostored procedures

·        privilege-based security model for jobs

·        naming of jobs and comments in jobs

·        stored, reusable schedules

Features in releases after 10g Release 1include :

·        dependencies between job units (10gR2 and up)

·        scheduling based on financial calendars and fiscalquarters (10gR2 and up)

·        event based jobs which run when an event is received (10gR2and up)

·        running of jobs on remote machines (11gR1 and up)

·        e-mail notifications on job events of interest (10gR2 andup)

·        starting a job based on arrival of a file (10gR2 and up)

另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。