Oracle® DBA Automation Quick Reference

Scheduling Reference

This section defines some of the most common and/or important scheduling parameters. Each parameter is in its own section, and each section begins with a syntax example and a table of the properties of the parameter, and has a description of how the parameter is used following the table.

DBMS_JOB

SUBMIT

DBMS_JOB.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 any_instance,
 force   IN BOOLEAN DEFAULT FALSE );

Table 4-2. DBMS_JOB.SUBMIT Parameters

Parameter	Description
job	Returns the number assigned to the submitted job. Assigned from the sys.jobseq sequence.
what	Defines the body of the ...