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)
本文题目:dbms_schedulervsdbms_job
链接地址:http://pwwzsj.com/article/pogjso.html