If your Mac is off or in sleep mode, the alarm won’t be able to go off. You’ll need to make sure your Mac is awake and running at the time the alarm is scheduled.