Re: pgagent

On 11/5/20 1:07 PM, Gabi Draghici wrote:
> 
> Hi,
> 
> I have installed postgresql 12 on sles 15 for some tests. Now I'm 
> interested in some sort of scheduler and from what I've read so far, 
> pgagent should do the job. So I've installed pgagent 4.0. I've added a 
> job (which I can see in pgagent.pga_job) but everytime I ran it (from 
> pgadmin) nothing happens ! When I start the pgagent I can see "... 
> pgagent ... connection authorized" in the main log. What else should I 
> check ?

pg_cron:

https://www.citusdata.com/blog/2020/10/31/evolving-pg-cron-together/

For pgagent what is the job doing and when? Could it be it hasn't run 
because it has not reached it's scheduled time.

> 
> Thanks,
> Gabi
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com