PLease help

[Petrucci, Joseph]

I do this with Sybase and it should still work this way i MSSQL 2K.
 
I would use a passive check (info on this is in the manual)  that reads the errorlog. Then you will have to have your procedure execute a raiserror in the event of failure or any other message you want. Have the plugin look at the error log for specific error numbers that you define in the master.dbo.syserrors table (If there still is one) 
 
Joseph A. Petrucci
E Systems DBA
------------------------------------------------
Desk: 412-220-2646
Cell: 412-916-2867
Text message (e-mail) 4129162867 at mobile.att.net
e-mail joseph.petrucci at ddiworld.com
Personal Cell: 724-462-0443
Personal e-mail: japetrucci at hotmail.com

________________________________

From: nagios-users-admin at lists.sourceforge.net on behalf of Forough, Hamid
Sent: Tue 10/11/2005 11:45 AM
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] PLease help



I need to know how to write a custom plugin that checks results of a stored procedure in MSSQL 2k and returns Yes or NO? I am using 2b4 verision of Nagios

 

 

 

Thanks,
Hamid

Advanced Micro Devices

 

W: 512.602.4704
C: 512.971-5345
E: hamid.forough at amd.com
 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20051011/9a032ecb/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 2669 bytes
Desc: image001.gif
URL: <https://www.monitoring-lists.org/archive/users/attachments/20051011/9a032ecb/attachment.gif>