FWIW As part of our daily backup scripts we run checkdb on all production databases prior to the daily backup taking place. If problems are found then the database doesn't get backed up. This will then get picked up by whoever's doing the SQL checks the following morning and investigated.

Nothing worse than finding out you've been backing up corrupt databases for the last month or so!