SQL Server 2012 Data Alerts without Sharepoint
Hi,
I like the idea of Data Alerts in SS 2012 but we do not use Sharepoint at all in our company. There are no intentions to migrate to SP, so I'd like to avoid it.
Is there any way to get the Data Alert functionality in SS 2012 without Sharepoint? Workaround, 3rd party solution, etc.
Any idea is welcome.
Cheers
April 11th, 2012 5:21am
Hi,
data alert is SSRS (2012) functionality, check this MSDN link:
http://msdn.microsoft.com/en-us/library/gg492252.aspx
Regards
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2012 6:27am
Hello,
Follow the links below for more information
http://technet.microsoft.com/en-us/library/ms170438.aspx#DataAlerting
http://msdn.microsoft.com/en-us/library/gg492252.aspx
http://lynnlangit.wordpress.com/2012/02/27/quick-look-data-driven-alerts-for-ssrs-in-sql-2012/
April 11th, 2012 7:06am
Thanks for the general information about Data Alerts.
But I still need to know if I can use Data Alerts WITHOUT Sharepoint.
Cheers
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 3:20am
Hi
To my understanding, Data Alerts requires SharePoint with SQL Agent Jobs running.
Without SharePoints we couldn't have alternate options. Please check it from Microsoft
http://technet.microsoft.com/en-us/edge/microsoft-virtual-academy-breakthrough-insights-using-sql-server-2012-reporting-services-and-visualization-module-2-introducing-self-service-alerting.aspx
I think, it will help youPrav
April 12th, 2012 4:42am
Hello,
You cannot create Data alert without Sharepoint Uptil now as the report must be saved in SharePoint Library to generate the data
alert which actually internally uses agent job to track a perticular data field of your report.
This feature can be used with SSRS files RDL's and cannot be with Power View yet, but do not know in future Microsoft may make this available without Sharepoint and Power View too :)
But its a wonderful feature and very good development.
Cheers, Ashish
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2012 8:52am