PG_CRON doesn't work

Question

Hi, I have a RDS instance, I was used to running maintenance sql statements using pg_cron but for some reason it has stopped working and I can't seem to work out why. I no longer can see any activity in cron.job_run_details and my parameters in my RDS instance stay the same. I have also tried the following `UPDATE cron.job SET nodename = '';` with no luck. Can anyone please advise?

Answer

Hi ,

I understand you are trying to run maintenance sql statements using pg_cron and it has stopped working.Please correct me if I misunderstood.

The pg_cron extension is supported on RDS for PostgreSQL engine versions 12.5 and higher. Please verify your engine version if it is updated to the supported one.

Please also verify if you have done the following :

1)Is cron_job enabled

2)Enabling the pg_extension,granting permissions to the pg_cron,scheduling pg_jobs following the link[1].

3)For further assistance you can contact AWS Customer Support to review your RDS instance[2].

I hope the above is helpful.

Reference

[1]https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_pg_cron.html

[2]https://aws.amazon.com/premiumsupport/knowledge-center/

PG_CRON doesn't work

Relevant content