Oracle7 Server Distributed Systems Volume II: Replicated Data

CHAPTER 10. Using Job Queues

This chapter describes how to use job queues to schedule periodic execution of PL/SQL code.

This chapter discusses

the initialization parameters you need to set to use job queues

the DBMS_JOB package and its procedures that allow you to manage jobs in the job queue

troubleshooting problems with job execution

the data dictionary views you can use to examine job queue information

Note: The job queue facility is part of the standard Oracle7 Server product, and requires no special options. The symmetric replication facility makes extensive use of job queues to propagate changes between sites, and this information is provided in this document as a convenience to you.

Attention: Remember to commit you job queue changes.

Additional Information: See the Oracle7 Server Administrator's Guide for more detailed information about job queues.

Job Queues

Using the job queue, you can schedule routines to be performed periodically. A routine is any PL/SQL code.

To schedule a job, you submit it to the job queue and specify the frequency at which the job is to be run. You can also alter, disable, or delete jobs you have submitted.