Learn complex job management
with dbms_scheduler
Dr. Tim Hall’s book “Oracle
Job Scheduling” has become the best source for complex job
scheduling, a very important feature for Oracle systems that
traditionally used UNIX crontabs to schedule batch jobs.
Yak Shaving also has outstanding instructions for scheduling batch
jobs in his blog, with
superb working examples:
“Oracle database
offers a job queue for scheduling certain operations to happen
routinely in a database. The functionality is similar to UNIX cron
jobs with the primary difference being if your database is not
running, the job will not attempt to run.
Scheduling is
accomplished through the DBMS_JOB package which is provided by Oracle.
While nearly anything can be scheduled, my rule of thumb is to use
this only for things which happen exclusively within the database. For
tasks which involve manipulating files at the operating system level I
still prefer cron.
Oracle will start a
coordinator job queue (CJQ0) process to handle scheduled jobs. The
CJQ0 process will keep track of the schedule and start helper
processes (J000 – J999) to execute the scheduled jobs (sic).”
|
