SQL Server Performance Forum – Threads Archive
DBCC logDear 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
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
"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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.