Import Excel Table & SQL script

By automation, I would like to run a series of scripts at different times. Can this be done?

_________________________________________

Robert J. Casaletta

Nissan North America, Inc.

Senior Analyst

Warranty Department

robert.casaletta@nissan-usa.com

Phone: +1 615.725.0973

Mobile: +1 615.720.6501

eFax: +1.615.967.2151

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Wednesday, February 10, 2016 1:46 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Import Excel Table & SQL script

RE: Import Excel Table & SQL script

Reply by John Dorlon

  1. go to Automation Designer (the toolbar icon for it looks like a lightning bold with a pencil). You can set up an “Import Table Data” action there. Once it’s set up you can rt-click it to run it, or to run from command line, the command would be something like “Toad.exe –a “Import Table Data1”” (or whatever you named the action).

  2. I’m not sure what you mean by “run automatically”. If you mean by command line - there is an “Execute Script” action that can be set up in the automation designer and run from command line in a similar way to executing the data import from command line. If you meant something else, let us know.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.