Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 To send mails

Author  Topic 

sravan1729
Starting Member

5 Posts

Posted - 2008-06-04 : 05:34:15
Sir,

I have KPIs (key performance indicators) in cubes(developed using SQL Server Analysis)..Now i can get the KPI status if required in reports when iam creating reports.My intention is to trigger mails to particular recipient when the KPi status changes to -1 and Cube is refreshed..

Do i have any option in SSRS(SQL Server Reporting Services) to trigger mails automatically when the cube gets refreshed..If i have any option to do so kindly suggest me the necessary solution..

Looking forward to an early reply..

Thanks in advance!!
   

- Advertisement -