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:
Enable e-mail notification for alerts.
Configure E-Mail Settings of Reporting Services Configuration Manager.
Configure SQL Server Agent Service.
Step 1: Enable e-mail notification for alerts
Navigate to Administration | Site Configuration | Sites.
In the Ribbon, click on Configure Site Components and select E-mail Notification.
On the General tab, check Enable email notification for alerts, and specify the smtp server amd the sender's address. Click on OK:
