To do that requires that you have a list of email addresses ... hardly seems worth doing this in SQL. If you are trying to alert users that the server is about to become unavailable, you need to consider that they probably won't get the email until after it is unavailable (or even back up again).