SQL Stored Procedure Monitoring

Question

Hello,I have a SQL stored procedure that I need to monitor.  The stored procedure is scheduled to run evey hour and I need to monitor and alert on any results that do not have 'Success' in the EventStatusDesc column.What is the best approach for monitoring this?

autarch · Accepted Answer

Following up on this for anyone else.  If you monitor a stored procedure via SQL Agent, you're only seeing the result after it's scheduled to run and the results only persist at runtime, whereas if you have LogicMonitor run the stored procedure, you can schedule the frequency in the DataSource and the results persist in LogicMonitor.  I found this gives you more reliable alerting and monitoring.To accomplish this I leveraged the JBDC data source; constructed the JBDC URL, ensured the L...