On the general tab of the step's properties, select the correct database, and then enter the following for the command: EXEC master..xp_smtp_sendmail @TO = 'you@you.com', @from = 'someone@somewhere.com', @subject = '<job name> failed.', @server = 'smtp.yourdomain.com' Of course, you can add @message and other parameters if you wish.