vellezz.info

SELECT
    'EXEC ReportServer.dbo.AddEvent @EventType=''TimedSubscription'', @EventData='''  + CAST(a.SubscriptionID AS VARCHAR(40)) + '''' AS ReportCommand
             ,b.name AS JobName
            --, a.SubscriptionID
            , e.name as Ename
            --, e.path
            --, d.description
                    
            ,d.LastStatus
            ,d.EventType
            ,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 sending mail%'
order by Ename

wykonujemy execi z pierwszej kolumny.