Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

Figure 12-36. Creating a data alert

2. On the New Data Alert screen, configure the data alert by giving the alert a
   name. In this case, name it DA_Referral to Admission Chart_GT_8.9 as shown
   in Figure 12-37.


3. Next, click the Add rule... button to create a rule that states when the value of
   the Category Group1 is greater than 8.9. This will cause the SQL Server Agent
   to send out an alert when the value is over 8.9.


4. Set the schedule to run once a day. The scheduler is much like the one
   provided by Report Manager.


5. Enter the recipient to be alerted when the value reaches the desired threshold,
   the subject, and any description if desired.


6. Click the Save button to have SharePoint create the alert.