If you're the kind of person that jailbreaks their iPhone in order to customize it to the Nth degree, then altering your notification sounds is no doubt high on your list of priorities. A new jailbreak tweak sets about making just that as easy as possible, but it'll cost you $1.99 for the privilege.
