Page 1 of 1

How to MSSQL server agent availability

Posted: Thu Mar 10, 2016 1:32 am
by 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

Re: How to MSSQL server agent availability

Posted: Thu Mar 10, 2016 10:24 am
by 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

Re: How to MSSQL server agent availability

Posted: Wed May 11, 2016 4:04 am
by gselvakumar
Issue sorted :D
Thanks

Re: How to MSSQL server agent availability

Posted: Wed May 11, 2016 9:52 am
by 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.