So you could do everything you ask in several languages and might even find one already written if you look. I use the program called “/usr/bin/play” to play sounds, like a wav file for instance like this one that comes with alsa “/usr/share/sounds/alsa/test.wav”. The terminal command “sleep integer” defaults to seconds and is easy to use in a bash script, but you can append m for minutes, h for hours and d for days. You can check the actual date and time in a bash script as well and do something when the time matches what you are looking for.
For writing bash scripts, I can start you off with this one you can find here:
You can find many sounds online when you look around and some also included with Windows if you have it. KDE has some default sounds you can borrow if you wish.