Home > Articles > Data > SQL Server

Whats Going On? Using SQL Server Web Wizard to Display Maintenance Results

📄 Contents

  1. What’s Going On? Using SQL Server Web Wizard to Display Maintenance Results
  2. The History Channel
  3. The Web Assistant Wizard
  4. Summary
  • Print
  • + Share This
In this article, Buck Woody shows you how to use the Web Wizard feature of SQL Server 2000 to publish data automatically from a database, no coding required. He uses a practical example of displaying the results of a maintenance plan history published to an HTML page each morning to check the status of the database.
From the author of

SQL Server 2000 makes maintaining databases exceptionally easy by creating an automated maintenance plan, but many DBA's bury their heads in the sand when it comes to checking to see whether the maintenance plans are actually working properly. True, the server can e-mail the results of maintenance plans, but what if you're on the road, or if all you have is a browser? What if your environment is primarily UNIX-based? Is there no way to check the status of maintenance plans from afar? The answer is yes, using an amazing SQL Server feature, the Web Assistant Wizard.

Maintenance Plans

Before I show you how to create the page that displays the status of a maintenance plan, let's examine what a maintenance plan does. A maintenance plan for a SQL Server 2000 database (or multiple databases) is created using a simple wizard that does one or more of three things:

  • Checks the consistency of a database

  • Runs optimizations on a database

  • Backs up a database and logs

  • + Share This
  • 🔖 Save To Your Account