BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation

You can create database maintenance plans on a Microsoft Data Engine (MSDE) installation by using the Database Maintenance Plan Wizard in the SQL Server 7.0 Enterprise Manager that is installed on another remote workstation. However, you cannot edit or delete the Database Maintenance plans on MSDE after they are created because there is not a "Database Maintenance Plans" node in the Enterprise Manager tree when you view an MSDE installation.

You can manually edit or delete SQLMAINT jobs in the Management/ SQL Server Agent/ Jobs node of the Enterprise Manager tree.

Microsoft has confirmed this to be a problem in SQL Server 7.0.

The SQLMaint.exe file performs maintenance operations on one or more databases. You can use SQLMaint.exe to run database consistency checker (DBCC) checks, back up a database and its transaction log, update statistics, and rebuild indexes.

You can create SQLMAINT jobs on an MSDE installation by running the Database Maintenance Wizard and using Enterprise Manager on a remote workstation.

REFERENCES

For additional information about SQLMaint.exe for MSDE, click the article number below to view the article in the Microsoft Knowledge Base: SQL Server Books Online; topic: "sqlmaint Utility"

For additional information about installing MSDE, see the Readme.txt file in the MSDE Web download package or in the MSDE CD.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base: Resources for developers building applications with MSDE, including white papers, general additional FAQS, and sample code can be found at the following Microsoft Web site: