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!
Search found 3 matches
- Mon Aug 16, 2010 9:02 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: Logging / Calling SQL
- Replies: 5
- Views: 11819
- Mon Aug 16, 2010 8:21 am
- Forum: Configuration, Maintenance, Troubleshooting
- Topic: Logging / Calling SQL
- Replies: 5
- Views: 11819
- 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...