在 分发数据库 中执行代码:
---查看事务传送记录
SELECT dis_his.agent_id AS [代理ID],
CASE dis_his.runstatus WHEN 1 THEN N'开始' WHEN 2 THEN N'成功' WHEN 3 THEN N'正在进行' WHEN 4 THEN N'空闲' WHEN N'5' THEN N'重试' WHEN 6 THEN N'失败' ELSE N'' END AS [执行状态],
dis_his.start_time AS [开始时间],
dis_his.duration AS [持续时间(s)],
dis_his.comments AS [详细信息]
FROM dbo.MSdistribution_history dis_his
WHERE
dis_his.comments LIKE N'%传递了%' ;
---查看快照传从记录
SELECT dis_his.agent_id AS [代理ID],
CASE dis_his.runstatus WHEN 1 THEN N'开始' WHEN 2 THEN N'成功' WHEN 3 THEN N'正在进行' WHEN 4 THEN N'空闲' WHEN N'5' THEN N'重试' WHEN 6 THEN N'失败' ELSE N'' END AS [执行状态],
dis_his.start_time AS [开始时间],
dis_his.duration AS [持续时间(s)],
dis_his.comments AS [详细信息]
FROM dbo.MSdistribution_history dis_his
WHERE
dis_his.comments LIKE N'%已应用%快照%' ;