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.
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