Blog Post

Core Infrastructure and Security Blog
3 MIN READ

SSRS Subscriptions (What goes on "under the hood")

TimPlesuk's avatar
TimPlesuk
Icon for Microsoft rankMicrosoft
Mar 15, 2019
First published on MSDN on Jun 20, 2016 One of the more difficult features to understand/troubleshoot that I've found in my experiences working with SSRS customers is the SSRS subscription functi...
Updated Apr 28, 2020
Version 4.0
TimPlesuk
SanthuWilly's avatar
SanthuWilly
Copper Contributor
Aug 30, 2020

Hi , 

I have been researching on web about this flow but this is the best and ultimate post that I have seen.

But I have few questions on dbo.Notifications table.

Currently we only kept 10 as running subscriptions and I would like to see how many minutes those 10 subscriptions are currently running.

I can able to find the duration only when a subscription is completed , but I would like to see the current running minutes of a subscription.

I found out that SQL Server Agent Job is just to trigger the subscription and it is not telling any duration , even the failed subscriptions are showing Success in SQL Server Agent Job (so I came to a conclusion that the job duty of the SQL Server Agent Job is to just trigger the subscription).

Can you please help me with these questions.

Thank you