Hi.
I'm writing a web application which is going to monitor our company's SQL servers.
Is there any way to test (using SMO) the status of SQL Agent service (running, not running)?
I'm browsing through classes but can't find anything related to it. It's easy to get Jobs' status but not Agent's status itself...
Any help is really appreciated.
Thank you.
Marcel