Re: How to schedule long running SQL job

Katz,

This is a good article. I am going try these.
Thanks,
Sarwar

________________________________
From: Jonathan Katz <jonathan(dot)katz(at)excoventures(dot)com>
Sent: Wednesday, July 19, 2023 8:48 PM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: John Scalia <jayknowsunix(at)gmail(dot)com>; pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to schedule long running SQL job

On Jul 19, 2023, at 8:34 PM, M Sarwar <sarwarmd02(at)outlook(dot)com<mailto:sarwarmd02(at)outlook(dot)com>> 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