What are the different subprograms provided with the DBMS_JOB Oracle supplied package?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are the different subprograms provided with the DBMS_JOB Oracle supplied package?
Rating:
The subprograms provided with the DBMS_JOB Oracle supplied package schedule and manage jobs in the job queue. The following table describes the subprograms provided with the DBMS_JOB package:
| SUBMIT procedure | Submits a new job to the job queue. |
| REMOVE procedure | Removes a specified job from the job queue. |
| CHANGE procedure | Alters any of the user-definable parameters associated with a job (e.g., the job description, the time at which the job will be run, or the interval between executions of the job). |
| WHAT procedure | Alters the job description for a specified job. |
| NEXT_DATE procedure | Alters the next execution time for a specified job. |
| INSTANCE procedure | Assigns a job to be run by an instance. |
| INTERVAL procedure | Alters the interval between executions for a specified job. |
| BROKEN procedure | Disables job execution (if a job is marked as broken, the Oracle server does not attempt to execute it). |
| RUN procedure | Forces a specified job to run. |
Rating:
Was this information helpful?
Other articles
- What are formal and actual parameters?
- What are the development steps for creating a package?
- What are the locations within a SQL statement from where user-defined functions can be called?
- What is a subprogram?
- What is system privilege?