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.
|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.