https://techcommunity.microsoft.com/blog/coreinfrastructureandsecurityblog/ssrs-subscriptions-what-goes-on-under-the-hood/370746
- SELECT n.SubscriptionID
,c.Name AS ReportName
,c.Path AS ReportPath
,u.UserName AS SubscriptionOwner
,n.ExtensionSettings
,n.NotificationEntered AS QueuedSinceTime
,n.ProcessAfter
,n.SubscriptionLastRunTime
,n.DeliveryExtension
FROM dbo.Notifications n WITH (NOLOCK)
INNER JOIN dbo.CATALOG c
WITH (NOLOCK) ON n.ReportID = c.ItemID
INNER JOIN dbo.Users u WITH (NOLOCK) ON n.SubscriptionOwnerID = u.UserID
WHERE n.ProcessStart IS NULL
AND (
n.ProcessAfter IS NULL
OR n.ProcessAfter < GETUTCDATE()
)
ORDER BY n.NotificationEntered
Comments
Post a Comment