InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 06:54:27 GMT20http://www.sqlservercentral.com/Forums/Topic1380698-338-1.aspxwill this help:[code="sql"];with LatestJobs AS(SELECT Job_id, step_id, max(convert(varchar(8),run_date)+RIGHT('000000'+CONVERT(varchar(6), run_time),6)) As LastRunfrom msdb.dbo.sysjobhistorygroup by Job_id, step_id)select j.job_id, j.name, next_run_date, next_run_time from msdb.dbo.sysjobs jjoin msdb.dbo.sysjobhistory h on h.job_id = j.job_idjoin LatestJobs lj on lj.job_id = j.job_id and lj.step_id = h.step_id and lj.LastRun = convert(varchar(8),run_date)+RIGHT('000000'+CONVERT(varchar(6), run_time),6)join msdb.dbo.sysjobschedules s on s.job_id = j.job_idwhere h.run_date < s.next_run_date and h.run_time < s.next_run_timeand convert(date,convert(varchar(8),ISNULL(NULLIF(s.next_run_date,0),19000101)),112) < convert(date, getdate())[/code]please do not hesitate to work and / or refine this further if it does not meet all your requirementsMon, 05 Nov 2012 05:21:52 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1380698-338-1.aspxHi,I have one query.i face one issue almost every day.We have lot of scheduled jobs configured ,some of jobs can't start on time as server may down at that time.Can i get the query which will show 'that job didn't run today 'Sat, 03 Nov 2012 05:25:08 GMTAlone