I actually hadn't planned on the followup for "how to do this", but I've gotten a bunch of responses, so maybe I should.

I've got a couple of systems that I've used and I'll takle one shortly. Basically it involves "staging" the data that needs to be sent out and then using the staging area as a basis for notifications.