On a regular N97 (may also work on a mini) go into "Messaging" and then scroll down to "My folders" in there you'll find another folder called "Templates" which contains 10 pre-written templates for various purposes, all of these are editable so you can either create a new one with your desired alarm codes on it or edit over an old one your not likely to use. Once it's done it'll save in there and went you want to use it you just simply choose send and pick the number from your contacts..
Not sure about the alert tone thing, I'll have a go on mine and let you know.
Big-Dan.