Microsoft KB Archive/323607

= PRB: Unable to View the Properties for a Database Maintenance Plan =

Article ID: 323607

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3a
 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Additional query words: SEM Enterprise Manager SQLAgent ErrorLogFile

Keywords: kbprb kbpending KB323607

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.