How to MSSQL server agent availability

[gselvakumar]

Hi,
I am able to monitor MSSQL server availability using NSclient++ but don't know how to monitor server agent availability.Can anyone pls help me with how to monitor MSSQL server agent availability.

Thank & Regards,
Gomathyshankar Selvakumar

[lmiltchev]

You can use "check_nt" with "-v SERVICESTATE" to check the status of your service. In most cases the name of the MSSQL server agent would be "SQLSERVERAGENT". Example:

Code: Select all

[root@localhost libexec]# /usr/local/nagios/libexec/check_nt -H <remote ip> -s welcome -p 12489 -v SERVICESTATE -l SQLSERVERAGENT -d SHOWALL
 SQLSERVERAGENT: Started

[gselvakumar]

Issue sorted
Thanks

[rkennedy]

Closing this one up and marking it resolved.

Feel free to create a new thread in the future if you have any further questions.