| warning |
title |
excerpt |
extension |
repo |
docs |
extension_star_count |
extension_star_count_pretty |
extension_download_count |
extension_download_count_pretty |
image |
layout |
DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there |
cronjob |
DuckDB Community Extensions
DuckDB HTTP Cronjob Extension
|
| name |
description |
version |
language |
build |
license |
maintainers |
cronjob |
DuckDB HTTP Cronjob Extension |
0.0.1 |
C++ |
cmake |
MIT |
|
|
| github |
ref |
quackscience/duckdb-extension-cronjob |
719904edf23617da02dfb599643452abf51db30e |
|
| hello_world |
extended_description |
-- Every 15 seconds during hours 1-4
SELECT cron('SELECT now()', '*/15 * 1-4 * * *');
-- Every 2 hours (at minute 0, second 0) during hours 1-4
SELECT cron('SELECT version()', '0 0 */2 1-4 * *');
-- Every 5 minute (wipe old data)
SELECT cron('DELETE FROM somewhere WHERE ts < NOW() - INTERVAL ''1 hour''', '* /5 * * * *');
-- Inspect running Jobs
SELECT * FROM cron_jobs();
┌─────────┬──────────────────┬────────────────┬──────────────────────────┬─────────┬──────────────────────────┬─────────────┐
│ job_id │ query │ schedule │ next_run │ status │ last_run │ last_result │
│ varchar │ varchar │ varchar │ varchar │ varchar │ varchar │ varchar │
├─────────┼──────────────────┼────────────────┼──────────────────────────┼─────────┼──────────────────────────┼─────────────┤
│ task_0 │ SELECT version() │ */15 * * * * * │ Fri Nov 15 20:44:30 2024 │ Active │ Fri Nov 15 20:44:15 2024 │ Success │
└─────────┴──────────────────┴────────────────┴──────────────────────────┴─────────┴──────────────────────────┴─────────────┘
-- Inspect running Jobs
SELECT cron_delete('task_0');
-- Supported Patterns
┌───────────── second (0 - 59)
│ ┌───────────── minute (0 - 59)
│ │ ┌───────────── hour (0 - 23)
│ │ │ ┌───────────── day of month (1 - 31)
│ │ │ │ ┌───────────── month (1 - 12)
│ │ │ │ │ ┌───────────── day of week (0 - 6) (Sunday to Saturday)
│ │ │ │ │ │
* * * * * *
|
This extension is experimental and potentially unstable. Do not use it in production.
|
|
30 |
30 |
508 |
508 |
/images/community_extensions/social_preview/preview_community_extension_cronjob.png |
community_extension_doc |
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};{% if page.docs.hello_world %}
{{ page.docs.hello_world }}```
{% endif %}
{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions
<div class="extension_functions_table"></div>
| function_name | function_type | description | comment | examples |
|---------------|---------------|-------------|---------|----------|
| cron | scalar | NULL | NULL | [] |
| cron_delete | scalar | NULL | NULL | [] |
| cron_jobs | table | NULL | NULL | [] |