Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

64bit SQL 2000 Cleaning files and subfolders

Status
Not open for further replies.

scimatic

Technical User
Aug 30, 2004
19
US
I'm working with 64bit SQL 2000 server and there is a stored procedure that executes and copies object files to a temporary directory where subfolders and files are stored. I want to create a solution to clean this directory and delete all the files and subfolders that are older then 3 days. I have a vbscript that will do this. The problem is that certain restrictions have been applied and I need to accomplish this WITHOUT using DTS or xp_cmdshell. At this point I can't think of any other way of executing the vbscript. Are there any alternatives?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top