I am using SQL Server 2005 SP2 and have created a maintenance plan job to clean up the maintenance plan log files. I went into the Maintenance Cleanup Task, selected Delete Maintenance Plan text reports from the following folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG with a txt extension, and chose to delete files older than 2 weeks.
I have tried to run the job several times and it is not deleting any of the files.
I use the same maintenance plan task to delete old backups and that works fine. Why doesn't it work when I try to delete the log files?
Please help. :crying: