Without using the wizard, I have made some maintenance plans (i.e. right-click maintenance plans and select new maintenance plan.)
...). When created in this manner, there is no alternative to specifying the location for the Maintenance Plan Action report. It is by default placed in the log subfolder of the program files folder for that instance of SQL Server. When creating maintenance plans using the wizard, you can specify the location for those report files.
After the I-fact, there can be no way to modify report file location The editing screen does not give you the option of specifying the location and there is no way to load the existing scheme in the wizard for modification. is not. When I look at T-SQL, I do not get any option for the report file.
Is there a way to change that location report report wizard of the Maintenance Plan?
Using SSMS, double click on your maintenance plan in Object Explorer. In the Object Explorer details, click on the "Reporting and Logging" icon (usually in the "Manage Connection" button) In this window, you can specify the location for the text file report.
Comments
Post a Comment