Different alert sounds for different modes

I would like to be able to hear a quiet alert during the day when I am awake, but a louder “wake me up” alert at night when I’m asleep. I’d like this to be set on the scheduler.

This is due to a spate of attempted thefts and although caught on video, the alarm was not enogh to wake anybody.