 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Introduction
This chapter will present information on how to
schedule Oracle jobs using the dbms_job and dbms_scheduler
packages supplied by Oracle. The dbms_scheduler package was
introduced in Oracle 10g, so the example code associated with these
sections will not work on previous versions. Where appropriate,
Enterprise Manager (EM) screen shots will be used to illustrate the
GUI/Web alternative to using the PL/SQL API.
The example code shows how objects can be
created, manipulated and dropped. In a number of cases, code
examples rely on previously created objects, which may have already
been dropped, so they will have to be recreated before it will be
possible to move on.
The following section will detail how to set up
a test environment to enable the running of any example code.
Setting up a Test
Environment
In order to use the examples in this chapter,
it is necessary to create a user to work with and define a task to
schedule. The following code creates a user called “job_user”
and grants it the necessary privileges. Some privileges used are
specific for Oracle 10g and should be ignored if a prior version is
used.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
