I know how important it is to run dbcc checks regularly, and to run it hassle free. I am actually trying to find out a script which can automate this task for me, and send me the reports for all the checks through mail. I need the dbcc checkdb output only if there is any errors after running consistency checks, and wouldn't really bother to get an e-mail if there is none. I also want to get a mail from all the linked servers that have been configured in my environment so that it gives me a complete list of only the error output from dbcc checkdb ignoring other messages, wherein I can quickly login to that server and rectify the things as per guidelines laid by Paul for various dbcc errors.
I hope if somebody could point me out to some links or at best can provide me a script to do this, in case if they have implemented what I am looking for.