Re: How to schedule long running SQL job

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Katz,

This is a good article. I am going try these.

Thanks,

Sarwar

---

From: Jonathan Katz <jonathan.katz@xxxxxxxxxxxxxxxx>
Sent: Wednesday, July 19, 2023 8:48 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: John Scalia <jayknowsunix@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: How to schedule long running SQL job

 

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