You get an email which contains the below

Job Name = Staging_Circle.MergeResourceToProcessWithResources

--------------------------------------

Step name = Circle.MergeResourceToProcessWithResources

DB Name = Staging_Database

Run Date = Nov 14 2012 11:08AM

Error = Unable...

http://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures

You will need to add a step to the end of every job which is got to by the on failure action of the other steps in the job but...

Doh, yeah I missed that part when reading your post, my bad, sorry on that.

Could you not make use of using DBMail instead if your passing over the results of...

No you dont need IIS.

You need to ensure that the server can connect to the relay machine, you send to a valid email address and that mass mail worms are...

Speak to your mail admin person, they should be able to help.

But it looks like your trying to send a mail to an address which doesnt exist.

What version of SQL are you running, Standard or Enterprise? If Standard then it will be multiple copies, if Enterprise you can use data driven subscriptions

Then you must be using an earlier full backup and not the current one from the latest 10:30 backup.

Check through the backupset table and correlate which log file it is...

What type of mail server do you use for SMTP? If its Exchange and you use the mail relay functionaity you need to ensure that you allow the IP...

We do backups to local disk, then the backups are backed up via the SAN backup, they are also shipped to the virtual tape array via NetBackup and they are...

Grognak the Barbarian

Also can you post the deadlock graph?

Why are you using the Jump to URL option and not the Jump to Report option and using parameter pass through?

Report in a different solution, report on a different server?

Nothing more? Nothing above or below that line?

Yes that is correct, you have to meet certain pre-reqs first and ensure that you add in the nessesary hints etc.

This link will describe more

http://msdn.microsoft.com/en-us/library/ms191244%28v=sql.105%29.aspx

What does the SQL error log say?