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

sp_getagentoffloadinfo

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.

Syntax

sp_getagentoffloadinfo [ @job_id = ] job_id

Arguments

[@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)

Remarks

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

Permissions

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

Show:
© 2015 Microsoft