Home Oracle Commands Oracle Packages
PL/SQL Books

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



Back to the Top

Simon Sheppard
SS64.com