I have a data file on a network file share. I need to determine the datetime of the file. This info is not in the file, so I need to get it from the file system. I have already written a .bat file that can do this, but here is the catch. The Run Program task does not like UNC file paths for the Run Directory parameter, it insists on a drive letter. When you publish an automation script to Toad Intelligence Server, it requires that all file paths are converted to UNC file paths. So when I publish a script with the Run Program task, it changes the Run Directory path to UNC format, and the Run Program task fails.
So here is the challenge. Can anyone tell me a way to determine the datetime of a file on a network file share without using the Run Program task? I don’t see any other task that would let me get that info, and using Oracle (dbms_lob.fileopen) is not an alternative option.