Can you also provide more information on what exactly this ' DBSS_Replication_Agent_Sessions' data collection is for and what it is checking?
The Replication Agent Sessions collection provides a detailed list of the selected agent’s closed sessions. In more recent SQL Server cartridges the collection "DBSS - Replication Agents Sessions" has been removed along with its alarms.
The SQL runs against the database returns a record set Agents Sessions completed of failed in last @interval_seconds
-- Run Status of the job execution:
--0 = Failed
--1 = Succeeded
--2 = Retry
--3 = Canceled
--4 = In progress
--5 = Retry
--6 = Failed
The SQL does an inner join on the MSdistribution_agents and MSdistribution_history tables from the monitored database.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center