December 13, 2012 at 10:16 am
Here's a start but I don't know how to identify the days. Help? I then need to take this list and disable. Then restart the list on Sunday after 2 am. TIA!
select
sj.name as job_name,
sjt.step_name,
ss.name as schedule_name,
ss.active_start_time
,ss.*
from sysjobs sj
join sysjobschedules sjs on sjs.job_id = sj.job_id
join sysjobsteps sjt on sjt.job_id = sj.job_id
JOIN sysschedules ss on ss.schedule_id = sjs.schedule_id
where 1=1
AND ss.enabled = 1 AND sj.enabled = 1
and
(
ss.active_start_time >= 210000
or
ss.active_start_time <= 2000
)
order by sj.job_id, sj.start_step_id, sjs.schedule_id, sjs.next_run_date, sjt.step_id
[font="Courier New"]ZenDada[/font]
December 13, 2012 at 7:22 pm
ZenDada (12/13/2012)
I got partial answers from @sqldba and @SQLfool on #SQLhelp. Can hack my way from there. So NM.
Cool! Can you share the solution, please? Thanks.
--Jeff Moden
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply