![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiX9Ie7N1MQSO5z7EZjjW1Br44zU438Ua1O73PeOIkSBxt92ZvT3zfq0WGsVPCHGjbmW8ez-XxjzLg-DTwKH1whRYIaG2innaraDI1KUxxsfnfAvarTMMvYY-P92etIH_YOgCkEl5whyBHI/s400/error_State.bmp)
ALL OF US DO NOT HAVE EQUAL TALENT. YET,ALL OF US HAVE AN EQUAL OPPORTUNITY TO DEVELOP OUR TALENTS. ~ Ratan Tata
Tuesday, October 27, 2009
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%'
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%'
Subscribe to:
Posts (Atom)