Is it possible to get notifications using SQL Server Reporting Services? Say for example I have a report that I want by mail if has for example suddenly shows more than 10 rows or if a specific value drop below 100 000. Do I need to tie Notification Services into it and how do I do that?
Please provide as much technical details as possible as I've never used Notification Services before.
Someone also told me that Notifications Services is replaced by new functionality in Reporting Services in Sql Server 2008 – is this the case?
Best Answer
I'd agree with Simon re Notification Services
Also, data driven SSRS Subscriptions are not available unless you use Enterprise Edition (and isn't available if you use SharePoint Integrated Mode).
An alternate way would be to create an Agent job that runs a proc. The proc could check the conditions you require and kick off the subscription if they are met using:
Where the @EventData is the ID of the subscription in dbo.Subscriptions.
This will drop a row in [dbo].[Event]. The Service polls this table a few times a minute to kick off subscriptions.
Really, this isn't far from what happens when you set up a new Subscription, might even be easier to create a Subscription in the Report Server site, find which agent job was created (the ones with GUID names) and edit the T-SQL.
Hope this helps