So I need to do three things?

1) Create an error message with number > 50000 in the sysmessages since this condition is something I will be testing for constantly.

2) Create an alert than fires when the error message I created is written to the log. Set up the alert with my email.

3) Modify my SP to do a raiseerror with my newly made message code and give it a severity of 19 so that it will trigger the alert.

Sound right?