ms dos, bat file

Question

ms dos, bat file

SD1999

Hall of Fame

Points: 3140
More actions
June 24, 2008 at 9:22 am

#123437

Hello everyone,
i am trying to create a batch file that will delete files that are older that 24 hours
what would be the dos command that i can put in that .bat file
thanks

Viewing 8 posts - 1 through 7 (of 7 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

I don't think a batch file can do that. I could be wrong, but del doesn't seem to have a property that will read file date, just name and extension. There are other solutions, depending on what type of files you are trying to get rid of. If it's backup files, a maintenance plan with a cleanup action can do it, for example.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

steveb. SSC-Forever Points: 46733 More actions · Answer 2

There are some really useful examples of Batch files on this site;

http://www.chebucto.ns.ca/~ak621/DOS/Bat-Adv.html">

http://www.chebucto.ns.ca/~ak621/DOS/Bat-Adv.html

They should have what you are after or something close that you can modify.

As this is a SQL forum, why don't you use a maintenance plan to do the delete?

steveb. SSC-Forever Points: 46733 More actions · Answer 3

GSquared (6/24/2008)
I don't think a batch file can do that. I could be wrong, but del doesn't seem to have a property that will read file date, just name and extension. There are other solutions, depending on what type of files you are trying to get rid of. If it's backup files, a maintenance plan with a cleanup action can do it, for example.

It can be done, but involves looping through the file names based upon the create/modify date and deleting based upon that.

Much easier to use a maintenance plan though.

SD1999 Hall of Fame Points: 3140 More actions · Answer 4

here is the story:

i am doing full backup to disk, daily

then Data Guard backup software does the backup to tape for those .bak files

it has an option, on success start the .bat or .exe file

this where i want this .bat file to delete all backups that older then 24 hours

but the whole purpose is to make sure that archiving to tape had ran successfully

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

Well, you could install Powershell, write a Powershell script to do it (which I am told is comparatively easy), then call the Powershell script from your .BAT file.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

SD1999 Hall of Fame Points: 3140 More actions · Answer 6

SD1999

Hall of Fame

Points: 3140

June 24, 2008 at 12:17 pm

#833528

thanks !!!!!!!!

RBarryYoung SSC Guru Points: 143329 More actions · Answer 7

Let us know how it works out. 🙂

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]