DBMS_JOB vs DBMS_SCHEDULER

by

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 :

  • logging of job runs (job history)
  • simple but powerful scheduling syntax (similar to but more powerful than cron syntax)
  • running of jobs outside of the database on the operating system
  • resource management between different classes of jobs
  • use of job arguments including passing of objects into stored procedures
  • privilege-based security model for jobs
  • naming of jobs and comments in jobs
  • stored, reusable schedules

Features in releases after 10g Release 1 include :

  • dependencies between job units (10gR2 and up)
  • scheduling based on financial calendars and fiscal quarters (10gR2 and up)
  • event based jobs which run when an event is received (10gR2 and up)
  • running of jobs on remote machines (11gR1 and up)
  • e-mail notifications on job events of interest (10gR2 and up)
  • starting a job based on arrival of a file (10gR2 and up)

More Related Contents:

  1. How to uninstall / completely remove Oracle 11g (client)?
  2. How can I set a custom date time format in Oracle SQL Developer?
  3. Get counts of all tables in a schema
  4. Determining location of relevant tnsnames.ora file
  5. Default row ordering for select query in oracle
  6. oracle convert unix epoch time to date
  7. Oracle trigger after insert or delete
  8. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  9. Difference between a user and a schema in Oracle?
  10. Base64 encoding and decoding in oracle
  11. What is the dual table in Oracle?
  12. How to avoid variable substitution in Oracle SQL Developer
  13. Recursion In Oracle
  14. creating parameterized views in oracle11g
  15. Oracle’s default date format is YYYY-MM-DD, WHY?
  16. PL/SQL print out ref cursor returned by a stored procedure
  17. Default Schema in Oracle Connection URL
  18. how to replace multiple strings together in Oracle
  19. Dynamically pivoting a table Oracle
  20. URL string format for connecting to Oracle database with JDBC
  21. Convert epoch to date in sqlplus / Oracle
  22. Why are Oracle table/column/index names limited to 30 characters?
  23. What is the difference between precision and scale?
  24. Get the number of days between two dates in Oracle, inclusive of the dates
  25. How to output result of SELECT statement which is executed using native dynamic SQL?
  26. Cursor For Loop with dynamic SQL-Statement
  27. Why cannot I create triggers on objects owned by SYS?
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment