Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
Examples of dbms_job Functions
PROCEDURE submit (
job OUT BINARY_INTEGER,
what IN VARCHAR2,
next_date IN DATE DEFAULT sysdate,
interval IN VARCHAR2 DEFAULT 'null',
no_parse IN BOOLEAN DEFAULT FALSE,
instance IN BINARY_INTEGER DEFAULT 0,
force IN BOOLEAN DEFAULT FALSE)
The parameters associated with these procedures
and their usage are as follows:
job - A number that uniquely
identifies the job.
what - A string that specifies
the actual work that should be executed by the job.
next_date - A date that
specifies the next time the job will run.
interval - A string that is
evaluated when the job is executed to determine the next time the
job should run. The value NULL means the job should not run again.
no_parse - A boolean that
indicates if the validity of the job specified in the what parameter
should be checked.
instance - The instance
number that is allowed to run this job, allowing the job queue
affinity to be set. By default, any instance can run the job.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.