Good Morning,
I have had an issue with the pre-2012 version of the DBCC CheckDB script … in the Catch statement on line 279 I have had to insert the error handling that you provide as part of lines 439 to 446 … my error was that TempDB wasn’t sized correctly and the only error I received was “The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction. [SQLSTATE 42000] (Error 50000)” with the additional error handing it logged the reason for the job failure as lack of space in TempDB. Aside from that it is extremely useful piece of code! 😀