What happened to Notification Services in SQL Server 2008?
The quick answer is that it’s been dropped. Microsoft posted the following in the
5.1 SQL Server Notification Services Removed from SQL Server 2008
Notification Services is not a component of SQL Server 2008, but will continue to be supported as part of the SQL Server 2005 product support cycle. In future releases, support for key notification scenarios will be incorporated into Reporting Services.