AnsweredAssumed Answered

How to change success criteria for a SQL job to look for TOTAL != 0

Question asked by scott.4.johnson on Jul 30, 2015
Latest reply on Jul 30, 2015 by scott.4.johnson

When I try TOTAL = 0, the job runs fine and I get a success (total is the result of a "select count(*) as total..." query where it returns no results). When I try TOTAL != 1, TOTAL < 1, or TOTAL <> 1, the job always fails and gives me a "Response Validation Failed" message for the reason.  Is there some syntax or trick I'm missing?

Outcomes