Hi. I currently have a set of Oracle SQL sensors configured to display the result of a query in numerical format. These sensors change throughout the day at random times. We're counting the number of records in a table.
What I'd like to do is... setup a notification that emails a group of people with the result of the last query. However, I'm not sure how to setup the Notifications section of the sensor. A "state change" notification never fires. A threshold notification (which I have set to email anything that goes above "0") only fires once.
What can I use to have this sensor send an email notification whenever the value of that channel changes ? In our care, it increases every minute or couple of minutes at random times.