pg_cron

pg_cron is a PostgreSQL extension that allows SQL jobs to be scheduled using cron syntax. It runs inside the database server and lets users automate routine tasks like VACUUM, backups, and custom SQL scripts. Jobs are managed via SQL commands and can run on the same schedule format as standard UNIX cron, making it powerful and easy to use for database administrators and developers alike.

Features

Schedule SQL tasks using cron syntax
Runs inside the PostgreSQL server process
Supports recurring and one-time jobs
Easily managed via SQL interface
Lightweight and minimal external dependencies
Ideal for automation of maintenance tasks

Project Samples

Project Activity

See All Activity >

Follow pg_cron

pg_cron Web Site

Other Useful Business Software

Compliant and Reliable File Transfers Backed by Top Security Certifications

Cerberus FTP Server delivers SOC 2 Type II certified security and FIPS 140-2 validated encryption.

Stop relying on non-certified, legacy file transfer tools that creak under the weight of modern security demands. Get full audit trails, advanced access controls and more supported by an award-winning team of experts. Start your free 25-day trial today.

Start Free Trial

Rate This Project

User Reviews

Be the first to post a review of pg_cron!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Related Categories

C Database Software

Registered

2025-06-04

Similar Business Software

DbVisualizer

DbVisualizer is a universal database client for developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

See Software
Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
Google Cloud BigQuery

BigQuery is a serverless, multicloud data warehouse that simplifies the process of working with all types of data so you can focus on getting valuable business insights quickly. At the core of Google’s data cloud, BigQuery allows you to simplify data integration, cost effectively and securely...

See Software
Google Cloud Platform

Google Cloud is a cloud-based service that allows you to create anything from simple websites to complex applications for businesses of all sizes. New customers get $300 in free credits to run, test, and deploy workloads. All customers can use 25+ products for free, up to monthly usage...

See Software
KS DB Merge Tools

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of...

See Software
dbForge Data Compare for SQL Server

dbForge Data Compare for SQL Server is a specialized GUI-based tool designed to compare table data in SQL Server without the necessity to write code. Key Features: - Support for SQL Server tables, views, data in backups, data in script folders, SQL Azure Cloud, and custom queries -...

See Software