--select * from sysjobactivity
--select * from sysjobhistory
--select * from sysjobs
SELECT sj.name AS 'Job Name', sjh.server AS 'SQL Server', LEFT(sjh.message, 20) AS Result, convert(varchar, sjh.run_date) AS 'Run Date'
FROM sysjobs AS sj, sysjobhistory AS sjh
WHERE sj.job_id = sjh.job_id AND sjh.step_name = '(Job outcome)' 
AND ltrim(rtrim(convert(varchar,getdate(),112))) = ltrim(rtrim(convert(varchar,run_date,112)))
--and sjh.run_date >= '20080921'
GROUP BY sj.name, sjh.server, sjh.message, sjh.run_date 
ORDER BY sjh.run_date DESC
--SELECT GETDATE()
--GO 
-- select convert(varchar, sjh.run_date) from sysjobhistory AS sjh
--and sjh.run_date = '20080923'
/*SELECT sj.name AS 'Job Name', sjh.server AS 'SQL Server', LEFT(sjh.message, 20) AS Result, sjh.run_date AS 'Run Date'
FROM sysjobs AS sj, sysjobhistory AS sjh
LEFT OUTER JOIN sj.job_id ON sjh.job_id and sjh.step_name = '(Job outcome)' 
GROUP BY sjh.server ORDER BY sjh.run_date DESC*/