sp_getagentoffloadinfo

Transact-SQL Reference

Transact-SQL Reference

sp_getagentoffloadinfo

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.