Report Subscriptions

Many organizations have a set of reports that need to be executed on a schedule instead of allowing ad hoc user access. SSRS provides the ability to automatically execute and deliver reports through the use of subscriptions.

Subscriptions can be created on an ad hoc basis for each user. When a user creates a subscription, they can specify the delivery format, settings for the deliver location, the rendering format for the report, an execution schedule, and any report parameters to use.



Each report subscription will create a job within SQL Server Agent based on the schedule settings specified by the user. Each subscription ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.