Two of the primary methods for automating the scripts and packages are DBMS_SCHEDULER
and Oracle Enterprise Manager. Each of these methods has its advantages and disadvantages.
DBMS_SCHEDULER can provide more control over how the task is scheduled and can be set
up using only a command-line interface. Oracle Enterprise Manager, on the other hand, uses a
completely web-based environment that allows a DBA to oversee a database environment from
wherever there is access to a web browser.
Using DBMS_SCHEDULER
New to Oracle 10g is the DBMS_SCHEDULER package. It provides new features and functionality
over the previous job scheduler package, DBMS_JOB. Although DBMS_JOB is still available in
Oracle 10g, it is highly recommended that your jobs convert to DBMS_SCHEDULER because the
DBMS_JOB package may be deprecated in a future release.
DBMS_SCHEDULER contains many of the procedures you??™d expect from a scheduling package:
CREATE_JOB, DROP_JOB, DISABLE, STOP_JOB, and COPY_JOB. In addition, DBMS_SCHEDULER
makes it easy to automatically repeat job executions with CREATE_SCHEDULE and to partition jobs
into categories based on resource usage with the CREATE_JOB_CLASS procedure.
200 Oracle Database 11g DBA Handbook
OEM Job Control and Monitoring
Not only can Oracle Enterprise Manager present most database administration tasks in a graphical,
web-based environment, it can automate some of the routine tasks that a DBA might perform on a
daily basis.
Pages:
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358