Database Query Monitor alarm not detecting health status

Database Query Monitor alarm not detecting health status

I am setting up a database query monitor. I am connecting to a database with a query and have selected Yes for 'show query output'. For now I am just testing with a simple query:
  1. SELECT 'MyJob' AS JobName, 0 AS JobStatus
Where 1 = healthy and 0 = unhealthy. For the purpose of testing I am explicitly setting the query to always return unhealthy.

I have selected 'MyJob' as the primary key. When I configure the alarm, I select 'JobStatus' as the attribute and have created a new threshold, which is defined as:

Critical if != 1
Warning if != 1
Clear if = 1

I apply this threshold to the JobStatus attribute and save the alarm. However, the health of the monitor is always showing green (healthy). I can see the query results are correctly returning 0 but for some reason it does not detect the threshold.

It is the first monitor I am configuring...please let me know what I am missing. Thank you!
              New to ADManager Plus?

                New to ADSelfService Plus?