Interrogates each linked SQL Server and returns true if the status of the SQLSERVERAGENT is set to Stopped. SQL Server does not always start up the agent upon reboot after a failure, even when set to do so.

Use SCOME with the proc master.dbo.xp_servicecontrol to interrogate the state of the Agent on each server.

This help guide can be hidden by clicking the minimise button on the right.