select job.name as SQLAgentJob, subscr.SubscriptionID, report.Name, report.Path, subscr.Description, subscr.LastRunTime, subscr.LastStatus from Subscriptions subscr join ReportSchedule sched on subscr.SubscriptionID = sched.SubscriptionID join Catalog report on sched.ReportID = report.ItemID join msdb.dbo.sysjobs job on cast(sched.ScheduleID as nvarchar(50)) = job.name order by report.name