Script to Show All Failed Jobs in Specified Period

-- CREATE PROCEDURE 

CREATE PROC check_failed_jobs @NumDays int
AS

SET NOCOUNT ON
PRINT 'Checking for all jobs that have failed in the last ' + CAST(@NumDays AS char(2)) +' days.......'
PRINT' '

SELECT CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11))AS 'Failure Date',
SUBSTRING(T2.name,1,40)AS 'Job Name',
T1.step_id AS 'Step #',
T1.step_nameAS 'Step Name',
T1.messageAS 'Message'

FROMmsdb..sysjobhistory T1
JOINmsdb..sysjobsT2
ON T1.job_id = T2.job_id

WHERET1.run_status != 1
ANDT1.step_id != 0
ANDrun_date >= CONVERT(char(8), (select dateadd (day,(-1*@NumDays), getdate())), 112)

GO

-- EXECUTE PROC and PASS NUMBER OF DAYS TO CHECK FOR
--   JOB FAILURES - example uses 2 days

check_failed_jobs 2