Scripting advice please.

[Kowalski]

Hello,

I need to create a script and run it as a scheduled task but no idea where to start.

Basically log files are added to a folder on a daily basis and the folder name is the date. I need to delete anything that is older than 7 days so I need to keep 7 folders that contain a file each.

If I can do this on a daily basis that would be ideal or a weekly basis at a push as the files are pushing 700Mb each.

Eg.

D:\folder1\folder2\folder3\datefolder\file.txt
The only folders I need in the datefolder are from the last 7 days and a new one is added each day.

I have not googled anything yet, thought I would ask here first.

Any help appreciated. Scripting is not my forte.

 

[TheBigD]

http://home7.inet.tele.dk/batfiles/monthly/dec2000.htm

HTH

 

[QwertyBerty]

If using Windows I would use Task Scheduler to setup a task to run an exe or batch file.

QB.

 

[Durbs]

I'd knock up a quick .NET console app and use the FileSystemWatcher class to perform an action when a new file/folder is created.

Created something similar for current clientco as they have similar, a SQL job that creates logfiles but they wanted them moved rather than removed and it works a treat. No need to schedule either as it wont act until it sees that folder altered.

Edit - of course depends on whether you are running Windoze.

 

[JoJoGabor]

Ask your manager what language he would prefer. In most support environments only the following would be considered in a Windows environment:

VBSCript
Powershell
WIndows shell

THis is so that other members in the team present and future have a good chance at maintaining and understanding this code.

 

[Durbs]

THis is so that other members in the team present and future have a good chance at maintaining and understanding this code.

The Indians can do .NET now too!

 

[lightng]

The Indians can do .NET now too!

Much cheaper and plenty quicker than you Durbs!

 

[Ardesco]

nncron lite is good for this sort of thing:

http://www.nncron.ru/

At its most basic the following would do:

cd D:\folder1\folder2\folder3\datefolder\
copy day6.txt day7.txt
copy day5.txt day6.txt
copy day4.txt day5.txt
copy day3.txt day4.txt
copy day2.txt day3.txt
copy day1.txt day2.txt

Just set nncron up to run it daily.

 

[Durbs]

Much cheaper and plenty quicker than you Durbs!

I can gladly do the needful!!!!

 

[Ardesco]

the above code would of course be a .bat file you set nncron to run daily