I have set up pg_cron on PostgreSQL 12. It was working properly. Suddenly it stops working with message LOG: cron job 1 job startup timeout.
I have tried below options still same message.
- I have restarted PostgreSQL service.
- Tried to create new job and tested.
- Removed pg_cron extension and recreated it.
There is no pg_cron parameter available to change timeout value.
Could anyone please share any hint?