如何在Oracle中管理计划任务（JOB）

原始链接：http://stackoverflow.com/questions/8505799/job-vs-scheduler-oracle-10g

At first glance it looks like only other names with more human readable schedules fordbms_scheduler, compared to?dbms_job. When looking slightly better, there are loads of differences, even in Oracle 10gR1. Currently we are in 11gR2. Every release?dbms_scheduler?gets more enhancements, where?dbms_job?has been static for many years.

Differences

• dbms_scheduler has logging
• dbms_scheduler has external jobs
• dbms_scheduler has job chains
• dbms_scheduler has job event handling (can raise and react upon events)
• dbms_scheduler has?resource manager?integration
• dbms_scheduler has human readable calendar syntax
• dbms_scheduler can combine different calendars in a new one

  In 11g extra

  • dbms_scheduler has remote external jobs
  • dbms_scheduler has light weight jobs - generate many low overhead jobs in one tx
  • dbms_scheduler can send mail on job completion
  • dbms_scheduler jobs can have multiple targets

    dbms_job can only run pl/sql type of jobs in the current database.

    I hope this (in complete list) h

    ?