Ah......

Yes on one server, I only set it up a couple weekends ago and someone has gone in and changed it to selected dbs. Thought I had checked that already.My bad!!. If the db is read-only then set it to read only with the relevant CRs and sign off.

FRUSTRATING!!!

However on a couple of 2005 servers all dbs are selected. The job runs for a minute. Then reports success. All dbs report that they have had no dbcc checkdb executed. I have 3 servers that do this all 2005. I have recreated the MP, with the same results and changed the run times.

All servers are 9.0.3042 SP2. I am aware that many bugs were fixed in SP3. Is this one.

I'll look to get these on SP4 asap. Never had issues with CHECKDB MP so I've never seen a reason to change it for change sake.

Doing some house cleaning in a new environment.