Home Forums SQL Server 2008 T-SQL (SS2K8) Job to delete folders older than X days old ? RE: Job to delete folders older than X days old ?

  • February 6, 2014 at 2:41 pm

    #1686789

    I run this as a SQL scheduled job on my Windows 2003 server:

    [font="Courier New"]ForFiles /P D:\objectscripts /D -180 /C "CMD /C if @ISDIR==TRUE echo RD /Q /S @FILE &RD /Q /S @FILE"[/font]

    It deletes the folders in D:\objectscripts older than 180 days. Not sure about the syntax, I just found it the other day on someone's website. Test it first in a non critical area.