Calls
-
PROCEDURE DBMS_JOB.BROKEN(jobIN BINARY_INTEGER,brokenIN BOOLEAN,next_dateIN 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(jobIN BINARY_INTEGER,whatIN VARCHAR2,next_dateIN DATE,intervalIN VARCHAR2,instanceIN BINARY_INTEGER DEFAULT NULL,forceIN 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(jobIN BINARY_INTEGER,intervalIN VARCHAR2); Changes the date expression used to determine the next execution date for job to interval.
-
PROCEDURE DBMS_JOB.SUBMIT(jobIN BINARY_INTEGER,whatIN VARCHAR2,next_dateIN VARCHAR2,intervalIN VARCHAR2 DEFAULT 'null',no_parseIN BOOLEAN DEFAULT FALSE,instanceIN BINARY_INTEGER DEFAULT any_instance,forceIN 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, ...