Brian Kalbfus wrote:
>
> The SQL will return a row if the jobhostagent field matches every time
> (the OR clause is on the same level as all the AND clauses). We need to
> group the last two clauses:
Thanks Brian, I've applied a patch per your suggestion.
Regards, Dave.
I have two jobs scheduled and the second one ran every poll interval,
regardless of any schedule I put in it. I traced the cause to the "host
agent" field being populated.
Looking at the source of pgAgent.cpp, from 5 weeks ago, I see the
following query being used to check if the agent should