MSsubscription_agents
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 | ID of the row. |
| publisher | sysname | Name of the Publisher. |
| publisher_db | sysname | Name of the publication database. |
| publication | sysname | Name of the publication. |
| subscription_type | int | Subscription type:
0 = push |
| queue_id | sysname | ID of the Microsoft Message Queue at the Publisher. queue_id is set to SQL for SQL-based queued updating. |
| update_mode | tinyint | Type of updating:
0 = read only |
| failover_mode | bit | If a failover type of updating was select, the type of failover chosen:
0 = immediate update is being used. Failover is not enabled. |
| spid | int | System process ID for the connection used by the Distribution Agent that is currently running or has just run. |
| login_time | datetime | 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 | For internal use only. |
| attach_version | binary(16) | Unique identifier representing the version of an attached subscription. |
| last_sync_status | int | Last run status of the Distribution Agent that is currently running or has just run. Status can be:
1 = Started |
| last_sync_summary | sysname | Last message of the Distribution Agent that is currently running or has just run. Status can be:
Started |
| last_sync_time | datetime | datetime when the last_sync_summary and last_sync_status columns were updated. Pull or anonymous distribution agents running as SqlServer Agent Service jobs will not update these columns. The history information will instead be logged to the job history table in that case. |