I’m running an automation in TDP 3.6 that is connecting to a Teradata Server. The script creates some volatile tables in Teradata database and finally executes a select statement that pulls the data into a csv file. All the code is included in a “Select to File” task. The code itself runs fine, but when I schedule the automation it runs and finishes few seconds later successfully according to windows task scheduler, however the code was not executed.
I tried with removing the volatile table’s code and doing only a select statement and the scheduled task works fine, so I guess there must be some kind of problem with the volatile tables. Is there way to make it work?
Thanks for your help!