Just wanted to know , is there a way to check in Flow Manager in SAS before the batch starts for all the flows whether all the relevant tables are closed in respective applications (Eg. SAS DI Studio, SAS EG).
I don't think so. How would you know what files are going to be affected without running the batch jobs? If you have a SAS dataset locking problem then there are other possible strategies that will help. What OS does your SAS servers run on and do your batch jobs run outside of normal business hours?