Re: How to schedule long running SQL job

[Jonathan Katz <jonathan.katz@xxxxxxxxxxxxxxxx>]

On Jul 19, 2023, at 8:34 PM, M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.Extensions.Trusted

 

This URL is a list of extensions that are marked as “trusted,” which means

that they can be installed by users without elevated privileges. A list of

extensions that are available on RDS can be found here. “pg_cron” is

included in this list:

https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html

It includes a link that provides guidance for how to use pg_cron on RDS:

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

Thanks,

Jonathan