What happened with the primary command to get the state of the service? I mean, sc (service control) executable?
You can run it from Command Prompt as
sc query sqlserveragent
or you can run it as a query from SQL Server:
Exec xp_cmdshell 'sc query SQLSERVERAGENT'
You can also run a script or a job of the type of ActiveX script using WMI to query the state of the services and send you results by email - I use it sometimes.
I sort of would like my point back for not checking the undocumented procedure with the error in the syntax.
Regards,Yelena Varsha