What is subscriptions in SSRS?

Subscriptions are useful in SQL Server Reporting Services (SSRS) for report scheduling and delivering reports as per a defined criterion. Users might want the reports in a specific format such as Word, Excel, HTML, PDF, etc. In this tip, we are going to explore different subscription options for SQL Server 2019 SSRS.

How does SSRS subscription work?

A Reporting Services subscription is a configuration that delivers a report at a specific time or in response to an event, and in a file format that you specify. Subscriptions can be used to schedule and automate the delivery of a report and with a specific set of report parameter values.

How to create a subscription in SSRs 2012?

I’m trying to create a subscription on an SSRS 2012 report, working from a SQL Server 2008 database. From what I’ve read elsewhere, if I store the credentials in an individual report / stored datasource in the Report Manager, I should be able to create a subscription. Unfortunately, for some reason this isn’t happening for me.

How are report subscriptions handled in SQL Server?

One report will allow us to run individual subscriptions of reports and the second will allow to run all subscriptions handled by a schedule. The automatic execution of report subscriptions is handled by SQL Server Agent. SSRS creates a separate agent job for each shared schedule and each individual schedule.

How does SSRs auto run report subscriptions on demand?

The automatic execution of report subscriptions is handled by SQL Server Agent. SSRS creates a separate agent job for each shared schedule and each individual schedule. The jobs are named by the GUIDs of that particular schedules as shown below which are not very useful.

Can a report server administrator delete a subscription?

Subscriptions can also be modified or deleted by report server administrators. A report server administrator cannot manage from one place all the individual subscriptions that are in use on a given report server. However, report server administrators can access each individual subscription to modify or delete it. To delete a subscription: