We have a batch file which runs a script and then creates a file which we use as flag for the next batch file.

Occasionally, the flag file is created before the script is complete causing the next step in the process to fail because it requires a table from the first step. Has anyone run across this problem and found a workaround?

Thanks,

Script
sqlplus -S ID/Password@vod @\\vodcaicluster\Oracle\DataMarts\CT\Scripts\in_rpt_CTBHK_Daily_Auth.txt > \\vodcaicluster\Oracle\DataMarts\CT\Output_Files\out_rpt_CTBHK_Daily_Auth.txt
dir> \\vodcaicluster\Oracle\events\censusflag.txt