SSRS Failed Subscription Notifications « Jeff Prom’s SQL Server Weblog
Great little query against your ReportServer db that you can create a report from to see subscription failures. A little tweaking and creativity and you’ve got the makings of a set of subscription management reports.
SELECT C.Name, S.LastRunTime, S.LastStatus, S.Description, Users.UserName
FROM Subscriptions AS S INNER JOIN
Users ON S.OwnerID = Users.UserID LEFT OUTER JOIN
Catalog AS C ON C.ItemID = S.Report_OID
WHERE (LEFT(S.LastStatus, 12) <> ‘Mail sent to’) AND (LEFT(S.LastStatus, 12) <> ‘New Subscrip’)
Popularity: 6% [?]
