SQL Server Agent and PostgreSQL Scheduled Lambda - SQL Server to Aurora PostgreSQL Migration Playbook

SQL Server Agent and PostgreSQL Scheduled Lambda

SQL Server Usage

SQL Server Agent provides two main functions: scheduling automated maintenance jobs and alerting.

Note

Other SQL Server built-in frameworks such as replication, also use SQL Server Agent jobs.

For more information, see Maintenance Plans and Alerting.

PostgreSQL Usage

Currently, there is no equivalent in Amazon Aurora PostgreSQL-Compatible Edition (Aurora PostgreSQL) for scheduling tasks but you can create scheduled AWS Lambda that will run a stored procedure. Find an example in Database Mail.