[dba-SQLServer]dbcc checkdb

In an effort to control any allocation and/or consistency errors with
SQL tables, I'd like to set up a job that would run dbcc_checkdb
everynight.

I would also like the results of this function to be emailed to a number
of people in our IT dept.

 

Has anyone done this before?  If so, can you offer any suggestions?

 

Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.