---

SELECT
    c.id AS job_id,
    r.key AS parameter,
    r.value::text AS value
FROM schedule.get_cron() c
CROSS JOIN LATERAL jsonb_each(c.rule) r
WHERE c.id IN (44, 45)
ORDER BY c.id, r.key;




SELECT
    c.id AS job_id,
    c.active,
    c.broken,
    c.start_date,
    c.end_date,
    c.next_time_statement,
    now() AS database_time,
    current_setting('TimeZone') AS database_timezone
FROM schedule.get_cron() c
WHERE c.id IN (44, 45)
ORDER BY c.id;