I have a software package that builds a comma delimited flat file - I am wanting to write a routine that will check the status of this file for when the software is done and no longer writing to it. I want to have it check to see if maybe the file is open or closed if still open - wait 10 mins and check again. Stay in this loop until the file is closed. Once I know the files is done I want to create a flag or trigger file so I can trigger other jobs to run based on the creation of this trigger file.
Ideas?
Thanks,
Ad.