Show TOC

sp_configure 'enable rep agent threads'Locate this document in the navigation structure

Enables or disables RepAgent thread integration in the Adaptive Server.

Syntax
sp_configure 'enable rep agent threads'[, 1 | 0]
Parameters
1

Enables RepAgent integration for the data server.

0

Disables RepAgent integration for the data server.

Usage

  • Use sp_configure 'enable rep agent threads' to enable RepAgent for Adaptive Server version 12.0 or later databases.

  • Use sp_configure 'enable rep agent threads' without options to display the current value, default value, and most recently changed value.

  • Enable RepAgent in this order:

    • sp_addserver – Identifies the Adaptive Server for RepAgent. You need to do this only once.

    • sp_configure 'enable rep agent threads' – Enables the data server for RepAgent. You need to do this only once.

    • sp_config_rep_agent – Enables the database for RepAgent.

    Refer to the Adaptive Server Enterprise Reference Manual for more information about sp_addserver.

Permissions

sp_configure requires “sa” or “sso” permission to modify configuration parameters.

Anyone can execute sp_configure to display information about parameters and their values.

Related Information