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


SELECT
    c.id,
    c.name,
    c.rule,
    c.commands,
    c.active,
    c.broken
FROM schedule.get_cron() c
WHERE array_to_string(c.commands, ' ')
          ~* '(sfr|smev|fns)'
   OR c.name ~* '(СФР|СМЭВ|ФНС)'
ORDER BY c.id;




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