oracleschedulerjob-schedulingdbms-schedulerdbms-job

DBMS_JOB vs DBMS_SCHEDULER


What is the difference between DBMS_JOB and DBMS_SCHEDULER ?


Solution

  • From other forums:

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

    dbms_scheduler is more robust and fully-featured than dbms_job and includes the following features that dbms_job does not have :

    Features in releases after 10g Release 1 include :