list_cron_backup_jobs

Column Type
uniform_resource_id TEXT
name BLOB
host_identifier BLOB
command BLOB
event BLOB
minute BLOB
hour BLOB
day_of_month BLOB
month BLOB
day_of_week BLOB
path BLOB
query_uri TEXT
cron_schedule
human_readable_schedule

SQL DDL

CREATE VIEW list_cron_backup_jobs AS
SELECT
    uniform_resource_id,
    name,
    host_identifier,
    command,
    event,
    minute,
    hour,
    day_of_month,
    month,
    day_of_week,
    path,
    query_uri,
    minute || ' ' || hour || ' ' || day_of_month || ' ' || month || ' ' || day_of_week AS cron_schedule,

    CASE
        WHEN hour GLOB '[0-9]*' AND minute GLOB '[0-9]*' THEN
            'Runs at ' || printf('%02d', hour) || ':' || printf('%02d', minute)
        ELSE
            'Runs on schedule: ' || minute || ' ' || hour || ' ' || day_of_month || ' ' || month || ' ' || day_of_week
    END AS human_readable_schedule
FROM ur_transform_list_cron_backup_jobs
;