I have a interesting requirement that may or may not be able to be fullfilled using sql extended stored procedures like xp_cmdshell. I'm not familiar with these XSP's so I figured I'd drop it by the list...
I need to examine many directories and move their contents to other directories on a schedule. At first I was simply going to use some combination of DOS's XCOPY, DELETE/ERASE, or MOVE commands. However, there is one requirement for my problem that these DOS commands can't accomodate.
I need any files that are currently in use NOT to be moved from the source directory.
Has anyone encountered anything similar and solved it with SQL? I ask because I am most familiar with SQL. However, if anyone has another suggestion on another language that might be able to do this, please let me know.
Thanks in advance.
Ryan