sp_configure 'enable rep agent threads'

Enables or disables RepAgent thread integration in the Adaptive Server.

Syntax

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

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.

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

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