PRB: Unable to View the Properties for a Database Maintenance Plan (323607)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) 8.0
  • Microsoft SQL Server 7.0
This article was previously published under Q323607

SYMPTOMS

In SQL Server Enterprise Manager (SEM), after you right-click an existing database maintenance plan, and then click to select Properties, the Properties dialog box of the database maintenance plan may flash, and then close automatically and you are back in SEM.

CAUSE

SQL Server Agent logging is turned off. You have not configured a file name for the error log in the SQL Server Agent properties.

WORKAROUND

To work around this behavior, follow these steps to set SQL Server Agent logging on:
  1. Stop the SQL Server Agent.
  2. Expand your server group, and then expand your server.
  3. Expand Management, right-click SQL Server Agent, and then click Properties.
  4. In the File name text box, under Error log, type a valid path and file name, or find a path by using the Browse button. Make sure that the SQL Server startup account has full control permissions for the path that you specify.
  5. Click Apply, and then click OK.

STATUS

Microsoft is researching this problem and will post more information in this article when the information becomes available.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbpending kbprb KB323607
©2003 Microsoft Corporation. All rights reserved.