Hello all members, here's my question: db version 14.5 we have to create a pg_agent job with 2 steps: 1_step execute query: if query result is true or find > 0 records then process next step, else it stops executing job 2_step execute batch command we tried to seta as 1_step the query: SELECT EXISTS (SELECT * FROM mytable WHERE someconditions) but even if it returns false 2_step is always executed. Need some help, thanks in advance, Giovanni --
best regards