Create a SQL job with script that picks up the status
If you have monitoring in place - you could generate an alert that goes to the server event logs if not right
The other option is sp_send email assuming you can send emails from the server. (Configure DB Mail first)