Sql Query HealthCheck

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.

Pre-requisites

The account identity that Wolfpack runs under will need to have the appropriate Sql LOGIN and SELECT permissions to the Sql entities.

Configuration

TODO
  • 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.

Last edited Mar 25, 2014 at 3:33 AM by jimbobdog, version 2