sql2008 中关于作用的系统表

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

转载于:https://www.cnblogs.com/aji88/archive/2011/04/25/2026790.html