SQL 2000 - tsql to find out failed jobs in last 24 hours
SELECT
    j.[name]
  , jh.run_date
  , jh.run_time
  , jh.sql_severity
  , jh.message
FROM
    msdb.dbo.sysjobhistory jh
INNER JOIN msdb.dbo.sysjobs j
ON  j.job_id = jh.job_id
WHERE
    jh.run_status = 0 -- Failure
AND jh.run_date &gt; DATEADD(DAY, -1, GETDATE())
ORDER BY
    jh.run_date DESC