日期:2014-05-17 浏览次数:20481 次
select a.name 'JobName',b.step_name 'StepName',d.name,b.command
from msdb.dbo.sysjobs a
inner join msdb.dbo.sysjobsteps b on a.job_id=b.job_id
inner join msdb.dbo.sysjobschedules c on a.job_id=c.job_id
inner join msdb.dbo.sysschedules d on c.schedule_id=d.schedule_id
where a.enabled=1 and d.enabled=1