Re: Cron not running

On Thu, Mar 28, 2024 at 5:28 PM Lok P <loknath(dot)73(at)gmail(dot)com> wrote:

> Hello All,
> In RDS postgres(version 15.4), we have scheduled partition maintenance
> through pg_partman and it's scheduled through pg_cron as below. The same
> script has been executed in dev and test environments, and we are seeing
> the cron job is scheduled in both environments because we see one record in
> table cron.job.
>
> But we are not seeing any entries in cron.job_run_details for the test
> database and also partitions are not getting created/dropped as we have
> expected on the test database. So it means it's not running in one of the
> databases. Wondering why it is so, if we are missing anything? How to debug
> this issue ,find the cause if it's failing internally for some reason and
> fix it ?
>

Permissions is the first possibility. Have you checked the RDS logs?

>