Change SQL Server Maintenance Plan Report Location?

sql-server-2008 maintenance-plan
RWGodfrey picture RWGodfrey · Jul 20, 2010 · Viewed 13.1k times · Source

I created some Maintenance Plans in SQL Server 2008 without using the wizard (i.e. right-click on Maintenance Plans and select New Maintenance Plan...). When created that way, there is no option to specify 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.

I can't find a way to modify the report file location after-the-fact. The edit screen doesn't give you the option of specifying the location and there doesn't appear to be a way to load an existing plan into the wizard for modification. When I view the T-SQL, I don't see any option for the report file.

Is there a way to change the location that the Maintenance Plan Action Reports go to without recreating the plans using the Wizard?

Answer

dscone picture dscone · Aug 27, 2010

Using SSMS, double click on your Maintenance Plan in the Object Explorer. In the Object Explorer Details, click on the "Reporting and Logging" icon (typically next to the "Manage Connections" button). In this window, you can specify the location for text file reports.

Related questions

SQL Maintenance Cleanup Task Working but Not Deleting

I have a Maintenance Plan that is suppose to go through the BACKUP folder and remove all .bak older than 5 days. When I run the job, it gives me a success message but older .bak files are still present. I've …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More