Sql Query Health Check
This check allows you use a Sql SELECT query as the driver for a notification. Wolfpack will execute the Sql SELECT and raises a notification based on the number of rows returned - the check can be configured to interpret the number of rows returned as success or failure.
The account identity that Wolfpack runs under will need to have the appropriate Sql LOGIN and SELECT permissions to the Sql entities.
- InterpretZeroRowsAsAFailure controls how the row count is interpretted as a result. Set this to true and the check result will indicate a failure if the query returns no rows. Set it to false to make a non zero rowcount a failure.