magento-cron-job-search.sql

set @datetime  = '2015-03-25 10:30:00';
set @threshold = 15;
 
select
    job_code,
    status,
    messages,
    executed_at,
    finished_at,
    timediff(finished_at, executed_at) run_time
from cron_schedule
where (
        executed_at > date_sub(@datetime, interval @threshold minute)
        and executed_at < date_add(@datetime, interval @threshold minute)
) or (
        finished_at > date_sub(@datetime, interval @threshold minute)
        and finished_at < date_add(@datetime, interval @threshold minute)
)
order by executed_at, finished_at;