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
ParameterDescription
jobReturns the number assigned to the submitted job. Assigned from the sys.jobseq sequence.
whatDefines the body of the ...

Get Oracle® DBA Automation Quick Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.