I'm interested in this too.
I don't use it when the n9 is off simply because it's not stable on my phone.
I never had it sound the alarm when off, only that it turns on and sound the alarm.
The problem with my phone is that it sometimes doesn't sound at all, only turn on, so it's totally unusable for me.
Perhaps it's caused because i use a custom mp3 file?