Maintenance Cleanup Task Does Not delete old text files

[JohnBates]

hi everyone,

Using 2005 SP2

I have built several Maint plans to perform tasks such as deleting old .bak, .trn and .txt files

The Maint Plan reports (.txt files) seem to build up forever; the task doesn't remove them and I have to manually take care of them.

This is the T-SQL executed by 1 of my plans:
EXECUTE master.dbo.xp_delete_file 1,N'E:\MicrosoftSQLServer\Backups',N'txt',N'2009-02-11T16:56:22'

Is this a known issue? If it is a bug, does SP3 fix it?

Thanks, John

 

[JohnBates]

aha - I need to install Build 3175 (aka Cumulative Update package 2 for SP2)

Thanks, John