Find failed job in SQL Server using Query

Use msdb

go

Select j.job_id,j.name,js.last_run_outcome,js.last_run_date,js.last_run_time,
jc.name as 'category'

from sysjobs as j inner join sysjobservers as js
on j.job_id=js.job_id

inner join syscategories as jc
on j.category_id=jc.category_id

where js.last_run_outcome = 0