Configuring report subscription

Report subscriptions in SQL Server Reporting Services provides the automatic delivery of specified reports by e-mail or to a file share at scheduled intervals. Use the Create Subscription Wizard in CM to configure report subscriptions.

Getting ready

Prepare a share folder (\\server\share\folder) for the report subscriptions, and allow write permissions to the subscription account for the share. 

Prepare notification settings for sending e-mail subscription reports using the following three steps:

  1. Enable e-mail notification for alerts.
  2. Configure E-Mail Settings of Reporting Services Configuration Manager.
  3. Configure SQL Server Agent Service.

Step 1: Enable e-mail notification for alerts

  1. Navigate to Administration | Site Configuration ...

Get Microsoft System Center Configuration Manager Cookbook - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial