记 sqlserver查询某时间区间内会执行的job

select A.job_id,B.name,A.StartTime from (
select job_id,min(SUBSTRING(convert(nvarchar(50), start_execution_date,120),12,10))StartTime
from msdb.dbo.sysjobactivity where start_execution_date is not null group by job_id
)A
left join msdb.dbo.sysjobs B ON B.job_id=A.job_id
WHERE A.StartTime>=‘07:25:00’ AND A.StartTime<=‘08:35:00’