Optimization and Integrity Error

Is there any way to run an optimization and integrity check against the
master and msdb databases? Below are the log files. Thanks!
- Gabe
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
Starting maintenance plan 'System Databases - Optimizations and Integrity'
on 6/2/2007 2:00:01 AM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[1] Database master: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs
to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement
not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database model: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other u
sers
are using the database 'msdb'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE st
atement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[3] Database msdb: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs
to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement
not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'System Databases - Optimizations and Integrity' on
6/2/2007 2:00:01 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)Gabe,
Sure, but you need to turn off the "repair minor problems" option.
http://support.microsoft.com/kb/290622
RLF
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uTngsk6pHHA.3892@.TK2MSFTNGP05.phx.gbl...
> Is there any way to run an optimization and integrity check against the
> master and msdb databases? Below are the log files. Thanks!
> - Gabe
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
> Starting maintenance plan 'System Databases - Optimizations and Integrity'
> on 6/2/2007 2:00:01 AM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
> database 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [1] Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statemen
t not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [2] Database model: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Database state cannot be changed while o
ther
> users are using the database 'msdb'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE
statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [3] Database msdb: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statemen
t not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'System Databases - Optimizations and Integrity'
> on 6/2/2007 2:00:01 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>|||Thanks!!
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23qevkq6pHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Gabe,
> Sure, but you need to turn off the "repair minor problems" option.
> http://support.microsoft.com/kb/290622
> RLF
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uTngsk6pHHA.3892@.TK2MSFTNGP05.phx.gbl...
>