Hi All, I have seen some posts on this, but could not find the exact script I needed:
EXECUTE master.dbo.xp_cmdshell 'forfiles /p "D:\Path" /s /m *.* /c "cmd /c Del @path" /d -7'
This works very well, but you need an MS operating system: Windows Server 2003 or Vista or newer version.
Hope this helps with deleting multiple files.