SCRIPT: How to check failed SQL Server Agent jobs?

DECLARE @Job_name varchar(128) = ''; --optional search for a specific job
SELECT TOP 100
CASE h.[run_status]
  WHEN 0 THEN 'Failed' WHEN 1 THEN 'Success'
  WHEN 3 THEN 'Cancelled'
  WHEN 4 THEN 'InProgress'
  ELSE 'Retry'
END AS JobStatus,
 j.name AS 'JobName',

 s.step_id AS 'Step',
 s.step_name AS 'StepName',
 msdb.dbo.agent_datetime(run_date, run_time) AS 'RunDateTime',
 ((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31 ) / 60)
         AS 'RunDurationMinutes',

h.[message]
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobsteps s
 ON j.job_id = s.job_id
INNER JOIN msdb.dbo.sysjobhistory h
 ON s.job_id = h.job_id
 AND s.step_id = h.step_id
 AND h.step_id <> 0
WHERE 1=1
AND j.enabled = 1   --Only Enabled Jobs
AND (j.name = @Job_name OR  @Job_name = '')

AND msdb.dbo.agent_datetime(run_date, run_time)
BETWEEN '2023-09-01' and '2023-10-10'
AND h.[run_status]  = 0
 
ORDER BY RunDateTime DESC