MSdistribution_history

The MSdistribution_history table contains history rows for the Distribution Agents associated with the local Distributor. This table is stored in the distribution database.

Column name	Data type	Description
agent_id	int	ID of the Distribution Agent.
runstatus	int	Running status: 1 = Start 2 = Succeed 3 = In progress 4 = Idle 5 = Retry 6 = Fail
start_time	datetime	Time to begin execution of the job.
time	datetime	Time the message is logged.
duration	int	Duration, in seconds, of the message session.
comments	nvarchar(255)	Message text.
xact_seqno	varbinary(16)	Last processed transaction sequence number.
current_delivery_rate	float	Average number of commands delivered per second since the last history entry.
current_delivery_latency	int	Latency between the command entering the distribution database and being applied to the Subscriber since the last history entry.
delivered_transactions	int	Total number of transactions delivered in the session.
delivered_commands	int	Total number of commands delivered in the session.
average_commands	int	Average number of commands delivered in the session.
delivery_rate	float	Average delivered commands per second.
delivery_latency	int	Latency between the command entering the distribution database and being applied to the Subscriber.
total_delivered_commands	int	Total number of commands delivered since the subscription was created.
error_id	int	ID of the error in the MSrepl_error system table.
updateable_row	bit	Set if the history row can be overwritten.
timestamp	timestamp	Timestamp column of this table.