What is the difference between DBMS_JOB and DBMS_SCHEDULER ?
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 :