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


SELECT
    c.id AS job_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;

SELECT
    id,
    name,
    is_active
FROM report.conf_scheduler_sfr
WHERE id = 40;

SELECT
    id_process,
    process_description,
    operation_type,
    active_task
FROM smev.smev_report_create_register_processes
WHERE id_etl = 40
ORDER BY id_process;