• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

How to automate DBCC CHECKDB in MS SQL 2016?

January 16, 2017

In this post I would like to show you how I solved the automation of DBCC CHECKDB. I had a meeting with a Microsoft engineer about MS SQL and he told me it is recommended to run this command runs regularly. At least once a week during the night hours because DBCC CHECKDB generates a lot of IO operations.


Here is my solution:


1) Create table CheckDB:



    - This Proc save the result of DBCC CHECKDB(0) WITH TABLERESULTS to the table CheckDB in the first step.


 I have created new job that consisted of 3 steps.


1 Step - Exec procedure DBCC_CHECKDB



2 Step - Delete rows when CreateDate is older than 2 months

3 Step - Send information mail with results



I hope you will find it as helpful as I do!




Please reload

Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon