Log file viewer field not big enough

[SQLWilts]

OK, so I am embarrassed to ask this...
I have a number of jobs that run DBCC commands against all databases on an instance.

Problem is that the command is failing somewhere (it is doing a checkdb against all tables/dbs) - and I don't know where - as in which table in which db is failing. The error log is giving me lots of good stuff, but then adding elipses (...) and then "the job failed".

Is there anywhere where the full and complete error is written? I have looked in the flat files, but again, just elipses - I am sure it is a field size limitation...

 

[mrdenny]

The job history only stores a few thousand characters max.

Edit the job step properties. On the advanced tab, give it an output path and run the job. After the job fails look at the log file. It'll be a full output of the DBCC commands.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[SQLWilts]

D'Oh!!

Thanks Mr D. I have to admit to having done exactly that ona contract 5 years ago - only remembered it AFTER I read your solution.

No excuses on my part

Brain fade comes with age, you know

thanks again

 

[mrdenny]

No problem.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog