Thanks for the info but to be more specific, it's this section of the ReportInventory report query that's giving us the headache:

(select top 1 cat1.Name

from Catalog...

Love the reports and for the most part they have been easy to add additional columns (Linked Report, Linked To, Hidden). One thing that we are trying to get...

Did you enable Alerts within the property section of SQL Agent? Right click SQL Server Agent->Properties->Alert System-> Enable mail profile. Then restart agent and try again.

Thanks for the replies. I found it was an EXECUTE AS 'domain\user' statement at the top of the Stored procedure that was causing the issue.

Thanks, I have tried that with the same results. I have also tried chaning the security in my linked server to use a remote server login mapping. I...