Distribution database table. Contains status information for the individual batches of transactions sent to subscribers.
| Column | Datatype | Description |
|---|---|---|
| publisher_id | smallint | The local server ID of the publishing server. |
| publisher_db | varchar(30) | The name of the published database. |
| job_id | int | The job ID. |
| subscriber_db | varchar(30) | The name of the database on the subscribing server. |
| subscriber_id | smallint | The local server ID of the subscribing server. |
| completion_time | datetime | The time the row was inserted. |
| status | int | The completion status. |
| delivery_latency | int | In seconds, the time between a job being inserted in the distribution database and being executed against the subscriber. |
| delivered_jobs | int | The number of jobs still in the distribution database that have already been executed against the destination database. |
| delivery_rate | int | The number of jobs per second that were executed in the last batch sent to that subscription server. |
ucMSsubscriber_status clustered, unique on publisher_db, publisher_id, subscriber_db, subscriber_id, job_id
| sp_MSsubscriber_status | sp_replcleanup |