I want to check for incorrect records in the sql server database. I don’t need a complex structure for this. I want the sql query to give a normal response if a 0 response is received, and a warning if a 1 is received. Especially the “Evaluate” part is very confusing for me. How can I set the alarm so that the query runs once a day and checks again every hour?
my sql query: select count(ID) from transferList where parameter3<>‘OK’
forum,