vbscript to delete files over certain days old

Question

vbscript to delete files over certain days old

QQ-485619

Ten Centuries

Points: 1195
More actions
November 10, 2010 at 11:19 am

#388203

I need some help to develop a vscript task to delete files over 14 days old. The files are located in d:\test folder.
Thanks,
Q

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

This link might help you.

http://www.google.co.in/search?hl=en&source=hp&q=vbscript+delete+files+older+than&aq=7&aqi=g10&aql=&oq=vbscript+delete+file&gs_rfai=%5B/url%5D

Pradeep Singh

Jeff Moden SSC Guru Points: 1004366 More actions · Answer 2

As a side bar, that's some funny stuff, right there. People won't allow xp_CmdShell but they'll allow VBS to be executed to delete files. I know I must be missing something here. Someone please explain. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Paul White SSC Guru Points: 150467 More actions · Answer 3

SQLCLR script to delete old backup and log files (for example):

http://www.mssqltips.com/tip.asp?tip=1374

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi