Use the query here to find your failed jobs.
http://sqlserverpedia.com/wiki/SQL_Server_Agent_Job_Query_Samples
To query backups for a database, you can query the backupset (and backup tables) in the msdb database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events