Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

Retrieves information about the offloading status of an agent from the Distributor. This stored procedure is executed at the Publisher on the publication database.


sp_getagentoffloadinfo [ @job_id = ] job_id


[@job_id = ] job_id

Is the replication agent Job ID. job_id is varbinary(16), with no default.

Result Sets
Column name Data type Description
offload_enabled int Specifies if offload execution of a replication agent has been set to run at the Subscriber. If 0, agent is run at the Publisher. If 1, agent is run at the Subscriber.
offload_server sysname Name of the server where the agent is running.

Return Code Values

0 (success) or 1 (failure)


sp_getagentoffloadinfo is used for all types of replication, but on push subscriptions only.


Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_getagentoffloadinfo.

© 2015 Microsoft