Calendar Alarm While Machine Sleeps
In Mountain Lion, the Reminders application is able to do this. You create a reminder, then open it up and check "remind me on a day." You can then set a time for the reminder. If your computer is asleep at the scheduled time, the reminder will show up next time it's awake.