select a.name, b.*,c.name
,case c.freq_type
when 1 then '一次'
when 4 then '每天'
when 8 then '每周'
when 16 then '每月'
when 32 then 'Runs when the SQL Server Agent service starts'
when 128 then ' Runs when the computer is idle' end
,freq_interval
,case freq_subday_type
when 1 then '在指定的时间'
when 2 then '秒'
when 4 then '分钟'
when 8 then '小时'
end
,active_start_date,active_end_date
,'每天,'+convert(varchar(10),active_start_time),active_end_time
freq_recurrence_factor
from dbo.sysjobs a,dbo.sysjobschedules b,sysschedules c
where a.job_id=b.job_id
and b.schedule_id=c.schedule_id
and c.freq_subday_type=1
and a.enabled=1
order by 1
