Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
Azure Database for PostgreSQL by design limits the number of databases containing pg_cron jobs metadata to only one. This is can be specified in the cron.database_name server parameter (the default...
#1: Initial revision
by
Alexei
·
2025-05-18T06:13:15Z (2 days ago)
Azure Database for PostgreSQL by design limits the number of databases containing `pg_cron` jobs metadata to only one. This is can be specified in the `cron.database_name` server parameter (the default is `postgres`).
PostgreSQL has a pretty good isolation between the databases on the same instances, so running cross-database queries is not trivial (as opposed to SQL Server).
When enabling `pg_cron` a custom function allows to specify the database the job non-query runs against. Example:
```sql
SELECT cron.schedule_in_database('JobName','*/10 * * *
*','CALL custom_procedure();','custom-db');
```