Hello:

I run this script

SELECT j.[name],

s.step_name,

h.step_id,

h.step_name,

h.run_date,

h.run_time,

h.sql_severity,

h.message,

h.server

FROM msdb.dbo.sysjobhistory h

INNER JOIN msdb.dbo.sysjobs j

ON h.job_id = j.job_id

INNER JOIN msdb.dbo.sysjobsteps s

ON j.job_id = s.job_id

AND h.step_id = s.step_id

WHERE h.run_status = 0 -- Failure

AND h.run_date > 2011-06-15

ORDER BY h.instance_id DESC

I have failed job, but I did not get any result. Where I missed. Thanks