Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page