vellezz.info

  use ReportServer;
SELECT
               b.name AS JobName
              , e.name as Ename
              , d.description
              ,d.LastStatus
              ,d.LastRunTime
              , date_created
              , date_modified
      FROM ReportServer.dbo.ReportSchedule a 
         JOIN msdb.dbo.sysjobs b ON cast(a.ScheduleID as varchar(40)) = b.name
         JOIN ReportServer.dbo.Subscriptions d ON a.SubscriptionID = d.SubscriptionID
      JOIN ReportServer.dbo.Catalog e ON d.report_oid = e.itemid
  where d.LastStatus like 'Failure%'
  order by LastRunTime desc, Ename