If you expect to be running this procedure on the same instance it is supposed to be checking, not going to work. If the instance is down, the job won't run, and the procedure won't be executed so it wouldn't be able to send an email to say the instance is down.