pgagent

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

pgagent

Henry Francisco Garcia Cortez
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



Reply | Threaded
Open this post in threaded view
|

Re: pgagent

Justin Clift-2
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