Cron

Assistance Cron is a Postgres module designed to schedule recurring Jobs with cron syntax directly within your database. Seamlessly integrated into the Assistance ecosystem, it allows users to automate tasks like executing SQL snippets, calling Database Functions, triggering Assistance Edge Functions, or syncing with external systems via webhooks.

Key benefits:

1. Just Postgres: Jobs and run details are stored and executed entirely in the database by leveraging the pg_cron database extension.
2. Versatile scheduling options: Supports standard cron syntax, sub-minute intervals, and natural language scheduling.
3. Assistance integration: Integrates seamlessly with the rest of the Assistance platform, including Assistance Edge Functions and Database Webhooks.
4. Zero network latency: Jobs are run directly in your database, eliminating network latency when executing SQL Snippets or calling Database Functions.
5. Enhanced observability: Monitor job history, debug errors, and review logs directly from the Assistance Dashboard.
6. Broad use cases: Automate a wide range of tasks, including database maintenance, analytics, performance optimizations, and syncing with remote systems.
7. Ease of use: Leverage an intuitive UI or SQL for scheduling, managing, and monitoring Jobs.