Toad World® Forums

Automation Designer: DMP files


We’re running TOAD for Oracle with Oracle 11g on a Database Server.

We log in on an application server via TOAD.

I wish to create a DMP file that is scheduled every week that is kept on the application server in a specific directory. I thought I would be able to do this via Automation designer. So I created a Data Pump Export in Automation server:

Selected schems and the schema I wished to DMP. Under the files tab, I can not enter a path for the dmp or log file. I can only choose the data_pump_dir or other oracle areas - I assume those would be on the database server.

Is there any way to accomplish what I would like to do, whether it be a different method in Automation Designer or some other way?