pgAgentPG16

pgAgentPG16 by EnterpriseDB is a lightweight, open-source job scheduler for PostgreSQL, built and packaged for PostgreSQL 16 environments. It runs as a background service (Windows) or daemon (Linux/Unix) to execute scheduled SQL commands and shell or batch scripts, making it easy to automate database maintenance, ETL workflows, and reporting tasks. Jobs and schedules are stored in the database, and you can create, manage, and monitor them through pgAdmin or SQL.

Key features:

• Designed for PostgreSQL 16 and compatible with EDB Postgres Advanced Server 16
• Multi-step jobs with success/failure conditions and dependencies
• Flexible scheduling with calendars, intervals, and exclusions (cron-like behavior)
• Concurrent execution of multiple jobs with configurable threading
• Detailed logging and history for auditing and troubleshooting
• Cross-platform service/daemon support for Windows and Linux/Unix
• Secure, role-based access via PostgreSQL roles
• Easy administration through pgAdmin; supports custom alerting via scripts

pgAgentPG16 is ideal for automating routine database operations, improving reliability, and reducing manual effort in PostgreSQL 16 deployments.

pgAgentPG16 is developed by EnterpriseDB. The most popular version of this product among our users is 4.2.