Yes, I need to know if the Job Ran on Schedule.

My Query should also take into account Schedule Changes.

The only way this could be done is looking at the Columns...

My Final select Select Statement is a follows (Copy of earlier Code below.)

------------------------------------------------------------------------------------------------

SELECT t1.Job_ID,

...

Below is the Query:

How do I know if the LastRun was actually the Real Latest Scheduled Run that should have taken place?

-------------------------------------------------------------------------------------------------

Use MSDB

GO

WITH LastExpectedRun_CTE (Job_ID, Name, MaxSessionID)

AS

(

...

Is there a way to find out if a JobRan on Schedule Programatically.

[FYI: I am still looking for some help on this Question.]

Question: By the way, are you sure you have the date 09/31/2010 in your table?

Answer: Yes

That's right. I had that in my query too.

select b.name as JobName,a.run_requested_date from sysjobactivity a, sysjobs b

where a.job_id=b.job_id

order by run_requested_date desc

But the Question is: How do I Positively Progamatically verify...

Thanks for sharing the Script, but I still cannot get the following Info.

(Assuming the time is 10/03/2010 5:30 PM)

a) SysServers has LastRun as 09/31/2010 8:00 am.

...