I restored a copy of the corrupted msdb on my local server and I run this query

ALTER DATABASE msdb

SET single_user WITH ROLLBACK IMMEDIATE;

go

DBCC checkdb ('msdb', repair_allow_data_loss);

go

ALTER DATABASE msdb

SET Multi_user WITH...

Thanks, I tried what you suggested.

These are the steps I used.

- In SQL Server Enterprise Manager, right-click the server name and

click Properties.

- On the General tab, clicked Startup...

Thanks for you response. In rebuilding can I just run the instmsdb.sql script? I can recreate the jobs if it gets wiped out.

Good Script.

My question is I have some reference tables in my Database. All other databases can be cleared with the exception of the reference tables.

Any help on that.

Thank you.

KP