Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgagent

pgagent

From
Henry Francisco Garcia Cortez
Date:
good afternoon why pgagent executes this query SELECT J.jobid   FROM pgagent.pga_job J  WHERE jobenabled    AND jobagentid IS NULL    AND jobnextrun <= now()    
AND (jobhostagent = '' OR jobhostagent = 'grafana') ORDER BY jobnextrun every second

--
Ing. Henry G. Cortez



Re: pgagent

From
Justin Clift
Date:
On 2020-10-06 08:29, Henry Francisco Garcia Cortez wrote:
> good afternoon why pgagent executes this query SELECT J.jobid   FROM
> pgagent.pga_job J  WHERE jobenabled    AND jobagentid IS NULL    AND
> jobnextrun <= now()
> AND (jobhostagent = '' OR jobhostagent = 'grafana') ORDER BY jobnextrun
> every second

Hi Henry,

Just to point out, the mailing list you sent this to is specifically
for PostgreSQL Website related discussion. ;)

You'll probably need to resend it, likely to the pgsql-general
mailing list:

   https://www.postgresql.org/list/

Hopefully someone there will be able to assist. :)

Regards and best wishes,

Justin Clift