Schedule jobs in Amazon RDS or Amazon Aurora PostgreSQL using pg_tle and pg_dbms_job
Database Blog
This article discusses how to use the pg_tle and pg_dbms_job extensions to schedule jobs with precise sub-minute scheduling in Amazon RDS or Amazon Aurora PostgreSQL-Compatible Edition. It provides a solution for customers migrating from Oracle databases who need to maintain critical business workflows and job scheduling.
Specifically, the article covers:
- An overview of the solution architecture and prerequisites
- Comparison of pg_dbms_job and Oracle's dbms_job
- Step-by-step instructions for setting up pg_tle and installing pg_dbms_job as a TLE extension
- Configuring pg_dbms_job parameters
- Testing the solution with examples of different job scheduling use cases
- Table maintenance and troubleshooting tips
- Cleanup steps to remove the deployed resources
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Oct 28
2024
2024
Schedule modifications of Amazon RDS using Amazon EventBridge Scheduler and AWS Lambda
Jun 4
2024
2024
Automate interval partitioning maintenance and monitoring in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL – Part 2
Nov 25
2024
2024
Run event-driven stored procedures with AWS Lambda for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL
Jan 27
2026
2026
Strategies for upgrading Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL from version 13
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.