Generally Available: Custom time zone support for pg_cron via cron.timezone in Azure Database for PostgreSQL

You can now modify the cron.timezone server parameter in Azure Database for PostgreSQL. This parameter controls the time zone used by pg_cron when evaluating scheduled jobs. By configuring cron.timezone, you can ensure scheduled jobs run according to your preferred time zone rather than relying on the server’s default setting.

This update is especially useful for applications that need job execution aligned with regional business hours or specific operational time zones. You can update the parameter through the Azure portal, Azure CLI, Azure Resource Manager, or REST API, and the change will apply to newly scheduled pg_cron jobs.

Learn more.