ALL OF US DO NOT HAVE EQUAL TALENT.
YET,ALL OF US HAVE AN EQUAL OPPORTUNITY TO DEVELOP OUR TALENTS. ~ Ratan Tata
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:
Post a Comment