|
PL/SQL Packages DBMS_JOB
Schedule and manage jobs in the job queue
Subprocedures:
SUBMIT Submit a new job to the job queue.
REMOVE Remove job from the job queue.
CHANGE Alter any of the user-definable parameters.
WHAT Alter the job description.
NEXT_DATE Alter the next execution time for a job.
INSTANCE Assign a job to be run by an instance.
INTERVAL Alter the interval between job executions.
BROKEN Disable job execution.
RUN Force a job to run.
USER_EXPORT Recreate a given job for export
and optionally set instance affinity.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:
Related Views:
DBA_JOBS USER_JOBS DBA_JOBS_RUNNING