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许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。