Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Overview and 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: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA