Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
Setting up a Test
Sat Jun 19 12:29:16 2004
MY_JOB_PROC Start: Test It!
Sat Jun 19 12:30:59 2004
MY_JOB_PROC End: Test It!
Obviously, these entries may be separated by
other messages, depending on what else has happened on the instance
during the time it took for the job to run.
Now that the user named job_user has
been created and granted privileges, it is time to schedule jobs.
The first step is the examination of the dbms_job package.
Examples of dbms_job Functions
Prior to Oracle 10g, the dbms_job
package was the preferred method for scheduling Oracle jobs. With
this package, jobs are created using either the submit or isubmit
procedures, whose call specifications are displayed below:
PROCEDURE isubmit (
job IN BINARY_INTEGER,
what IN VARCHAR2,
next_date IN DATE,
interval IN VARCHAR2 DEFAULT 'null',
no_parse IN BOOLEAN DEFAULT FALSE)
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA