yugabyte-db
yugabyte-db copied to clipboard
[YSQL] pg_cron extension
Jira Link: DB-2756
Description
This is the 3rd change in a series of diffs for porting the Postgres extension pg_cron to yugabyte. The following summary assumes you understand how the original pg cron extension works. See #11907 for brief description on how job assignment and execution will operate on Yugabyte.
This change ports all pg_cron extension code and scripts. Most of the existing code and scripts can be reused. Some SQL functions must be modified to include an optional nodename parameter which will allow users to schedule jobs on select Postgres processes in the cluster. These interface changes will still be compatible with the SQL function signatures that exist in v1.4-1 of pg_cron. The extension will also evenly distribute the cron job load across all nodes in the cluster, handle node failures and cron leader changes.