Загрузка данных


BEGIN;

UPDATE report.conf_scheduler_sfr
SET is_active = true
WHERE id = 40;

SELECT schedule.activate_job(44);
SELECT schedule.activate_job(45);

COMMIT;




SELECT
    c.id,
    c.name,
    c.rule->>'crontab' AS crontab,
    c.active,
    c.broken
FROM schedule.get_cron() c
WHERE c.id IN (44, 45)
ORDER BY c.id;