SELECT
cron AS job_id,
scheduled_at,
started,
finished,
status,
message
FROM schedule.get_log()
WHERE cron IN (44, 45)
AND scheduled_at >= current_date
ORDER BY scheduled_at DESC;
SELECT
l.id,
l.record_date,
l.status,
l.message
FROM robot.log l
WHERE l.record_date >= current_date + time '16:25'
AND l.session_id IN (
SELECT DISTINCT x.session_id
FROM robot.log x
WHERE x.record_date >= current_date + time '16:25'
AND x.message ~
'id[[:space:]]*=[[:space:]]*(14|40)([^0-9]|$)'
)
ORDER BY l.id;