I have created the app to pull dates from file and feed into the export dataset function using the substitute variable into the SQL query.
When i am running the action from top the toad automation is getting freezed/hanged and not able to see any errors or issues if there. I have to kill it finally and start new session to begin with.
I have never heard of it hanging before. If there is an error, it will be in the log.
Please export your app (from the left hand side, so it includes all of the actions), and email the file to me. you can send it to john.dorlon@quest.com. I will try to reproduce it.