Found this great article on extending some of the alerts functionality that SPS provides.  It shows an example of providing a "Toast" type alert on your desktop when an SPS Alert occurs.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_SP2003_ta/html/ODC_SPPTBuildingCustomChannelsSPPT.asp