NeophyteHello,
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?
ProfessorWhat specific steps would you do to check this by hand? Like can you check the state via a SQL statement you run on a regular basis? You mentioned a "EventStatusDesc column" so I assume this is in a database table you can query?
I see there is a "Custom SQL Queries" community module that sounds like it will run any SQL statement and store a numeral result in LM. If you can write a statement that say returns 0 for Success and 1+ for failures (and scheduled missed), that may meet your needs.
