Tuesday, October 6, 2009

SQL 2005 - Query to retrive SQL Agent Jobs scheduled time.

select j.name,sc.active_start_time,active_end_time,*
from sysjobs j
inner join dbo.sysjobschedules jsc
on j.job_id = jsc.job_id
inner join dbo.sysschedules sc
on jsc.schedule_id = sc.schedule_id
where j.name like '%ssis%'

No comments: