You may want to find a different way to meet your goals. Microsoft is discontinuing Notification Services in SQL Server 2008, so if you're just now planning to start using it, you'll be stuck on SQL Server 2005 or have to re-implement it a different way whenever you upgrade.