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)