CODEWITHSUNDEEP
oracle-database
kaissun
kaissun

Reputation: 3086

job VS Scheduler, Oracle 10G

Is there someone who can strictly give me what is the job (DBMS_JOB) and the scheduler (DBMS_SCHEDULER) in oracle? and what's its roles ?

Regards.

Upvotes: 2

Views: 12387

Answers (2)

user123664
user123664

Reputation:

At first glance it looks like only other names with more human readable schedules for dbms_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) helps

Upvotes: 13

fge
fge

Reputation: 121712

Both allow you to schedule jobs to be executed at a given time. The main difference is how you specify them, apart from that there is no noticeable difference in practice.

DBMS_SCHEDULER also allows you to set your custome schedule intervals, which DBMS_JOB doesn't. In fact,the most important difference is that DBMS_JOB is deprecated and will therefore be desupported before DBMS_SCHEDULER is.

Upvotes: 5

Related Questions