SUBMIT v11
The SUBMIT
procedure creates a job definition and stores it in the database. A job consists of a job identifier, the stored procedure to be executed, when the job is to be first run, and a date function that calculates the next date/time the job is to be run.
Parameters
job
Identifier assigned to the job.
what
Name of the stored procedure to be executed by the job.
next_date
Date/time when the job is to be run next. The default is SYSDATE
.
interval
Date function that when evaluated, provides the next date/time the job is to run. If interval
is set to null, then the job is run only once. Null is the default.
no_parse
If set to TRUE
, do not syntax-check the stored procedure upon job creation – check only when the job first executes. If set to FALSE
, check the procedure upon job creation. The default is FALSE
.
Note: The no_parse
option is not supported in this implementation of SUBMIT()
. It is included for compatibility only.
Examples
The following example creates a job using stored procedure, job_proc
. The job will execute immediately and run once a day thereafter as set by the interval
parameter, SYSDATE + 1
.
The job immediately executes procedure, job_proc
, populating table, jobrun
, with a row: