Managing Local Jobs

Oracle runs jobs in each site's job queue to automatically complete certain tasks that are necessary to manage a replication environment. You can also view and manage the job queues of each server in a replication system.

Oracle creates a job in the local job queue for a site on behalf of the following operations:

• When you create a scheduled link, Oracle creates a job to push deferred transactions to the target remote master site. The PL/SQL for this type of job includes the API call DBMS_DEFER_SYS.PUSH.

• When you schedule purging of the deferred transaction queue for a site, Oracle creates a job to perform this operation. The PL/SQL for this type of job includes the API call DBMS_DEFER_SYS.PURGE.

• When you create a master group, Oracle creates a job to push corresponding administrative requests to the other master sites that are participating in the master group (one job per destination). The PL/SQL for this type of job includes the API call DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN.

• When you create a refresh group, Oracle creates a job to perform regular refreshes for the group. The PL/SQL for this type of job includes the API call DBMS_REFRESH.REFRESH.

To learn more about managing a server's local jobs, follow a link:

• Displaying a Site's Local Jobs

• Creating a Local Job

• Editing the Properties of a Local Job

• Manually Running a Job

• Breaking or Enabling a Job

• Deleting a Local Job

• Creating a Copy of a Local Job

• Diagnosing Problems with Jobs