In SQL, Whether sysjobs will tell which jobs are failed? : In SQL, Whether sysjobs will tell which jobs are failed?

We have around 100 jobs running on SQL Agent. We have set up an email alert notification for any job failed.

Is there a way for us to run a query to identify list of Jobs are failed.

Below query will provide, list of jobs enabled.

    select * from MSDB.dbo.sysjobs where enabled = 1