Skip to content

configure-the-transaction-set-job-for-an-oracle-publisher.md

Latest commit

 

History

History
56 lines (39 loc) · 4.4 KB

configure-the-transaction-set-job-for-an-oracle-publisher.md

File metadata and controls

56 lines (39 loc) · 4.4 KB
title Configure transaction set job (Oracle Publisher)
description Learn how to configure the transaction set job for an Oracle Publisher publishing to a SQL Server Subscriber.
author MashaMSFT
ms.author mathoma
ms.date 09/25/2024
ms.service sql
ms.subservice replication
ms.topic how-to
ms.custom
updatefrequency5
helpviewer_keywords
sp_publisherproperty
Oracle publishing [SQL Server replication], configuring
dev_langs
TSQL

Configure the Transaction Set Job for an Oracle Publisher

[!INCLUDE SQL Server] The Xactset job is an Oracle database job created by replication that runs at an Oracle Publisher to create transaction sets when the Log Reader Agent is not connected to the Publisher. You can enable and configure this job from the Distributor programmatically using replication stored procedures. For more information, see Performance Tuning for Oracle Publishers.

To enable the transaction set job

  1. At the Oracle Publisher, set the job_queue_processes initialization parameter to a sufficient value to allow the Xactset job run. For more information about this parameter, see the database documentation for the Oracle Publisher.

  2. At the Distributor, execute sp_publisherproperty (Transact-SQL). Specify the name of the Oracle Publisher for @publisher, a value of xactsetbatching for @propertyname, and a value of enabled for @propertyvalue.

  3. At the Distributor, execute sp_publisherproperty (Transact-SQL). Specify the name of the Oracle Publisher for @publisher, a value of xactsetjobinterval for @propertyname, and the job interval, in minutes, for @propertyvalue.

  4. At the Distributor, execute sp_publisherproperty (Transact-SQL). Specify the name of the Oracle Publisher for @publisher, a value of xactsetjob for @propertyname, and a value of enabled for @propertyvalue.

To configure the transaction set job

  1. (Optional) At the Distributor, execute sp_publisherproperty (Transact-SQL). Specify the name of the Oracle Publisher for @publisher. This returns properties of the Xactset job at the Publisher.

  2. At the Distributor, execute sp_publisherproperty (Transact-SQL). Specify the name of the Oracle Publisher for @publisher, the name of the Xactset job property being set for @propertyname, and new setting for @propertyvalue.

  3. (Optional) Repeat step 2 for each Xactset job property being set. When changing the xactsetjobinterval property, you must restart the job on the Oracle Publisher for the new interval to take effect.

To view properties of the transaction set job

  1. At the Distributor, execute sp_helpxactsetjob. Specify the name of the Oracle Publisher for @publisher.

To disable the transaction set job

  1. At the Distributor, execute sp_publisherproperty (Transact-SQL). Specify the name of the Oracle Publisher for @publisher, a value of xactsetjob for @propertyname, and a value of disabled for @propertyvalue.

Example

The following example enables the Xactset job and sets an interval of three minutes between runs.

:::code language="sql" source="../codesnippet/tsql/configure-the-transactio_1.sql":::

Related content