Oracle in a Nutshell

Calls

PROCEDURE DBMS_JOB.BROKEN (job IN BINARY_INTEGER, broken IN BOOLEAN, next_date IN DATE DEFAULT SYSDATE);

Sets or unsets the Boolean broken flag for the job, and optionally sets the next execution date specified by next_date. Jobs flagged with broken = TRUE are not automatically executed.

PROCEDURE DBMS_JOB.CHANGE (job IN BINARY_INTEGER, what IN VARCHAR2, next_date IN DATE, interval IN VARCHAR2, instance IN BINARY_INTEGER DEFAULT NULL, force IN BOOLEAN DEFAULT FALSE);

Changes one or more of the parameters what, next_date, interval, or instance (new with Oracle8i) for job. If force (new with Oracle8i) is TRUE, any positive integer is acceptable for the instance; if force is FALSE, instance must be running.

PROCEDURE DBMS_JOB.INTERVAL (job IN BINARY_INTEGER, interval IN VARCHAR2);

Changes the date expression used to determine the next execution date for job to interval.

PROCEDURE DBMS_JOB.SUBMIT (job IN BINARY_INTEGER, what IN VARCHAR2, next_date IN VARCHAR2, interval IN VARCHAR2 DEFAULT 'null', no_parse IN BOOLEAN DEFAULT FALSE, instance IN BINARY_INTEGER DEFAULT any_instance, force IN BOOLEAN DEFAULT FALSE);

Submits a job with the specified job number and PL/SQL definition what, scheduled to execute at next_date and every interval thereafter, on instance instance (new with Oracle8i). If no_parse is TRUE, parsing of the PL/SQL in what is deferred until execution. If force (new with Oracle8i) is TRUE, any positive integer is acceptable for the instance; if force is FALSE, ...