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.