Alarm (VB6)

This is about as simple as it gets.  Alarm plays an alarm at a specified time. 

If you don't like the alarm included, put a WAV file called "alarm.wav" into the same directory as alarm.exe and the program will use that instead.

Check out Wakey for something a little more complicated.