Search found 3 matches

by HogHunter
Mon Aug 16, 2010 9:02 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: Logging / Calling SQL
Replies: 5
Views: 11819

Ok I had a duh moment. The issue was a syntax error in my SQL statement. I decided to try an ODBC test to see how HostMon connects to SQL. That is when I saw the error.

So now I am passing the %Reply% value into the stored proc and it works perfectly!
by HogHunter
Mon Aug 16, 2010 8:21 am
Forum: Configuration, Maintenance, Troubleshooting
Topic: Logging / Calling SQL
Replies: 5
Views: 11819

Alex, Thanks for the input. I will see if I can change the way the test is setup. In the meantime, I will answer your questions below as best I can with the current setup. So you want to execute action after each test probe regardless of test status? Then you should use "Repeat until status cha...
by HogHunter
Fri Aug 13, 2010 3:27 pm
Forum: Configuration, Maintenance, Troubleshooting
Topic: Logging / Calling SQL
Replies: 5
Views: 11819

Logging / Calling SQL

I was hoping to be able to have a test call a Stored Proc every time it runs. The idea is to log the results so I can establish metrics. I looked at the alerts and figured I could set an alert to fire for both bad and good conditions. Then I set the alert to fire on the schedule. The only problem is...