Did you try a search of the forums for "BBAlerts" or "BB Alerts?"
There's a dedicated thread in the Aftermarket Software forum and lots of other threads about it. Also, there is a FAQ at
BlackBerry FAQ - BlackBerryFAQ with links to many different 3rd party apps.