You can use Enterprise Manager to configure SQL Executive to run it.
SQL Executive is a seperate program that runs along side of SQL Server.
It can do many things like restart SQL Server if it dies, run all sorts
of scheduled task, etc.
In Enterprise Manager, Select "Manage Scheduled Tasks". Click on New
task. The type is TSQL. Enter "DBCC CheckDB(Emerald)" as the TSQL
statement and Master as the database (it doens't actually matter).
Then change the frequency to weekly on Sunday at say 3am. You have
to make sure SQL Executive is running and starts automatically as well.
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com