Starting RepAgent

Use sp_start_rep_agent to start RepAgent on Adaptive Server.

Prerequisites

There must be an entry for Replication Server in the interfaces file of the Adaptive Server.

Task

Normally, you need to start a RepAgent thread only if you:

Reconfigure the RepAgent parameters.
Explicitly shut down the RepAgent.

RepAgent starts automatically when Adaptive Server restarts if you had:

Started RepAgent at least once with sp_start_rep_agent and not stopped RepAgent with sp_stop_rep_agent.
Set auto start to true with sp_config_rep_agent.

Note: RepAgent can be restarted only if its associated database is fully recovered and online and log transfer is on for the connection to the primary database.

See Replication Server Reference Manual > Adaptive Server Commands and System Procedures for detailed information about each option of sp_start_rep_agent and sp_config_rep_agent.

Log in to Adaptive Server
At the isql prompt, enter sp_start_rep_agent.
For example, to enable RepAgent for the pubs2 database:
```
sp_start_rep_agent pubs2
```
(Optional) To automatically start RepAgent whenever Adaptive Server restarts:
```
sp_config_rep_agent 'auto start', 'true'
```