To check every database on a sql-2005 server for corruption (before an upgrade) I created a job with one step containing this code …
exec sp_msforeachdb 'DBCC CHECKDB(''?'') WITH NO_INFOMSGS'
… then in the advanced tab I created an output file d:\checkdb.log.
A few hours after I’d manually started the job I was happy to see the output file was empty.
Database Consultant 