MS SQL Agent - failed jobs

How can I add multiple Jobs to the below query?

Can anyone please help?

select
 sjs.last_run_outcome
 from
  msdb.dbo.sysjobs as sj,
  msdb.dbo.sysjobservers as sjs
  where sj.job_id = sjs.job_id and sj.name = 'backupsample'

I just wanted to clarify - you only need to add one line that is in bold in above snippet. All other lines have been added by the author for reference, so that you can find the right place to stick it in Hope helps someone

Great script - thanks for sharing!

Just... read above ?

Can someone please post the full working version of the sql query that removes the disabled tasks from the results.

The query above actually returns disabled jobs, just need to add this...

----

join msdb.dbo.sysjobs sj

  on jh.job_id = sj.job_id

  AND sj.enabled = 1

join msdb.dbo.sysjobactivity ja

  on jh.job_id = ja.job_id

Very nice addition as I don't want to see disabled jobs or jobs without a schedule either!