Contains history rows for previous updates to Subscriber. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
| agent_id | int | ID of the agent. |
| runstatus | int | Running status: 0 = Start 2 = Succeed 3 = In progress 4 = Idle 5 = Retry 6 = Fail |
| start_time | datetime | Time execution of the job began. |
| time | datetime | Time of this history entry. |
| duration | int | Cumulative duration, in seconds, of this session. |
| comments | nvarchar(255) | Message text. |
| delivery_time | int | Number of seconds it took to apply a batch of changes. |
| delivery_rate | float | Average delivered commands per second. |
| publisher_insertcount | int | Number of inserts at the Publisher. |
| publisher_updatecount | int | Number of updates at the Publisher. |
| publisher_deletecount | int | Number of deletes at the Publisher. |
| publisher_conflictcount | int | Number of conflicts at the Publisher. |
| subscriber_insertcount | int | Number of inserts at the Subscriber. |
| subscriber_updatecount | int | Number of updates at the Subscriber. |
| subscriber_deletecount | int | Number of deletes at the Subscriber. |
| subscriber_conflictcount | int | Number of conflicts at the Subscriber. |
| error_id | int | ID of an error in the MSrepl_error system table. |
| timestamp | timestamp | Timestamp column of this table. |
| updateable_row | bit | Set if the history row can be overwritten. |