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.

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 Aug 23, 2013 at 10:40 AM by jimbobdog, version 1