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 | Sites.

2. In the Ribbon, click on Configure Site Components and select E-mail Notification.

3. On the General tab, check Enable email notification for alerts, and specify the smtp server amd the sender's address. Click on OK:

   

Step 2: Configure...