The MSsubscription_agents table is used by Distribution Agent and triggers of updateable subscriptions to track subscription properties. This table is stored in the subscription database.
|Column name||Data type||Description|
|id||int||The ID of the row.|
|publisher||sysname||The name of the Publisher.|
|publisher_db||sysname||The name of the publication database.|
|publication||sysname||The name of the publication.|
|subscription_type||int||The subscription type:
0 = Push.
1 = Pull
2 = Pull anonymous.
|queue_id||sysname||The ID of the Microsoft Message Queue at the Publisher. queue_id is set to SQL for SQL-based queued updating.|
|update_mode||tinyint||The type of updating:
0 = Read-only.
1 = Immediate update.
2 = Queued update using Message Queuing.
3 = Immediate update with queued update as failover using Message Queuing.
4 = Queued update using SQL Server queue.
5 = immediate update with queued update failover, using SQL Server queue.
|failover_mode||bit||If a failover type of updating was select, this is the type of failover chosen:
0 = Immediate update is being used. Failover is not enabled.
1 = Queued update is being used. Failover is enabled. The queue being used for failover is specified in the update_mode value.
|spid||int||The system process ID for the connection used by the Distribution Agent that is currently running or has just run.|
|login_time||datetime||The date and time of the Distribution Agent connection that is currently running or has just run.|
|allow_subscription_copy||bit||Specifies whether or not the ability to copy the subscription database is allowed.|
|attach_state||int||Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.|
|attach_version||binary(16)||The unique identifier representing the version of an attached subscription.|
|last_sync_status||int||The last run status of the Distribution Agent that is currently running or has just run. The status can be:
1 = Started.
2 = Succeeded.
3 = In progress.
4 = Idle.
5 = Retry.
6 = Fail.
|last_sync_summary||sysname||The last message of the Distribution Agent that is currently running or has just run. The status can be:
|last_sync_time||datetime||The date and time when the last_sync_summary and last_sync_status columns were updated. Pull or anonymous distribution agents running as SqlServer Agent Service jobs do not update these columns. The history information instead logs to the job history table in that case.|
|queue_server||sysname||Internal use only.|