All geek questions in one place

Alternative to notification services

What a good alternative to notification services now that Microsoft has uninstalled it from Sql Server 2008. I don’t want to use the 2005 version or create my own from scratch. What third-party tools fill this niche?

Some NS features are now available through RS. However, our system requires “on demand” to start sending notifications. For example, at any time when a row in a table is added or updated, you need to send several emails with data.

Data-based subscriptions in Reporting Services are halfway (msdn.microsoft.com/en-us/library / ...), but we should be able to initiate reporting at will, rather than a pre-set schedule.

+3
source share
5 answers

The theory goes that notification services were deleted because it was deprecated by Reporting Services. And in truth, RS can play quite a lot of the role of NS. Have you explored how far you can drive an RS and replace your NS solution?

+1
source

Why not use SSIS and configure it as a job in SQL Server Agent? You can then use sp_start_job to drop it whenever you want, set up a trigger to handle it, or schedule it.

SSIS, xp_cmdshell proc dtexec . , , foreach SSIS .

0

Notification Framework CodePlex

http://nab.codeplex.com/

0

you might want to explore the Boomerang Notification Framework , which is an SQL-based framework for quickly developing notification solutions. Boomerang is also fully integrated with SSRS and supports many communication methods such as email, fax, twitter, etc.

0
source

You can use sp_send_dbmail in your SQL code to send email notifications according to your logic:

exec msdb.dbo.sp_send_dbmail
    @Profile_Name = 'Default',
    @Recipients     = N'yournotificationaddress@yourdomain.com',
    @subject = N'This step, with ' + CAST(@NumRecordsGenerated AS varchar(10)) + ' records generated, has succeeded!'
-1
source

Source: https://habr.com/ru/post/1709787/

More articles:


All Articles