DBCC log | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DBCC log

Dear all There is a regular job for DBCC to check whether there is any problem about the database. However, after the scheduled job completed. How can I check the result of the DBCC checking. Thanks in Advanced Kwan
02 Oct 2005
Hi,
you can check it with select * from msdb.dbo.sysjobhistory in order to get information about jobs execution state and error message if any . and what dbcc checking you wants to perform ! ? would you describe it more pricesly ? Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

SQL server error log is the best point of information to check whether DBCC has been completed or generated any errors. If not you can set that scheduled job to generate output. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>