I opened up your script Gianluca Sartori, but it is giving me some errors. I noticed that when you are creating the ##DBCC_OUTPUT table, you don't include the RowId field...

Well I moved it from 9:00pm to 9:15pm and same result.

Then when I run it manually at about 7:30am it runs fine. No errors.

I've got the other servers doing...

That is my current train of thought too. I've rescheduled the job for 20 mins after normal time to see if that helps.

So I finally went with this script:

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML =

N'<font face="Arial" size="+1" COLOR="#7AA9DD">Job Status Report</font>' +

N'<table border="0" cellpadding="3">' +

...

Ok, so I've got my script working nicely, but I'm now trying to work out the best way of sending myself an email every day with the results. I have...

Thank you. That is exactly what I am after.

Cheers! 🙂