I am using the Job Notification features of SQL Server 2005 to periodically scan certain database tables for records containing bad return codes. When bad return codes are detected, the SQL Server job uses the RAISERROR command to trigger an error severe enough to cause the job to fail. When the job failure occurs, the notification is setup to send an e-mail to a specific e-mail address. I would like the output of the job (i.e. SQL query) to be attached to the notification e-mail or available in the text body. Is there any way to accomplish what I would like to do using SQL Server 2005?