Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Enables remote agent activation of the replication push agent that is identified by the @job_id parameter. This stored procedure is run at the computer that is currently the remote agent server. This stored procedure is executed at the Publisher on the publication database.


sp_enableagentoffload [ @job_id = ] job_id
    [ , [ @offloadserver = ] 'remote_agent_server_name' ]
    [ , [ @agent_type = ] 'agent_type' ]


[@job_id = ] 'job_id'

Specifies the SQL Server Agent job identifier of the replication agent to be enabled for remote activation. job_id is varbinary(16), with no default.

[@offloadserver = ] 'remote_agent_server_name'

Specifies the network name of server to be enabled for remote agent activation. remote_agent_server_name is sysname, with a default of NULL. If NULL, then the current offload_server in the MSDistribution_agents table is used.

[@agent_type = ] 'agent_type'

Is the type of agent. agent_type is sysname, with a default of NULL, which specifies that the system will determine if the agent type is distribution or merge. Valid values are distribution or merge, or NULL.

Return Code Values

0 (success) or 1 (failure)


sp_enableagentoffload is used to enable the running of the Distribution Agent or Merge Agent processing to another server.

Upon successful completion of sp_enableagentoffload, the –Offload offloadserver parameter will be appended to the replication agent command line, or updated with the new remote_agent_server_name if the –Offload offloadserver parameter already exists in the command line.

Also, the offload_enabled field for the agent in MSDistribution_agents will be set to 1, and the offload-server field will be updated with the new value specified in the 'remote_agent_server_name', if provided.


Only members of the sysadmin fixed server role or db_owner fixed database role or the subscription owner of the specified agent can execute sp_enableagentoffload.

See Also

DTS Package Details

Remote Agent Activation

System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft