Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.