Toad World® Forums

How to execute multiple SQL files using Automation Designer

I am new to Automation Designer in Toad and I have some saved SQL scripts that I would like to schedule. However, after setting everything up and running the app I receive the following message prompt after the 1st SQL file is executed

What do I do to make Toad ignore this and not prompt for a response?

Can you show screenshot of your problem?

Trying to execute two stored SQL files and I get the following message after the first one. I just want the automation to run on through and ignore the errors.

Jonas Oglesby, Jr. | Sr. Finance Manager

O: 615.614.4114 – Jonas.Oglesby@Healthways.com

**Healthways, **a subsidiary of Sharecare, Inc.

Sharecare acquires Healthways’ Population Health Business ** Learn more**

From: Damir Vadas [mailto:bounce-damirvadas_250@toadworld.com]

Sent: Sunday, August 21, 2016 12:47 PM

To: toadoracle@toadworld.com

Subject: [External] RE: [Toad for Oracle - Discussion Forum] How to execute multiple SQL files using Automation Designer

RE: How to execute multiple SQL files using Automation Designer

Reply by Damir Vadas

Can you show screenshot of your problem?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.



This email contains confidential and proprietary information and is not to be used or disclosed to anyone other than the named recipient of this email, and is to be used only for the intended purpose of this communication.


Make sure this is unchecked.

From: Jayso [mailto:bounce-Jayso@toadworld.com]

Sent: Monday, August 22, 2016 8:02 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] How to execute multiple SQL files using Automation Designer

RE: How to execute multiple SQL files using Automation Designer

Reply by Jayso

Trying to execute two stored SQL files and I get the following message after the first one. I just want the automation to run on through and ignore the errors.

Jonas Oglesby, Jr. | Sr. Finance Manager

O: 615.614.4114 – Jonas.Oglesby@Healthways.com

**Healthways, **a subsidiary of Sharecare, Inc.

Sharecare acquires Healthways' Population Health Business ** Learn more**

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

You do not get an message but an error!
This is quite a big difference.

What I would do is to copy the content and run in SQLPlus logedin as the same user and databse (like in this example) and return the error (if you cannot fix it by yourself).

After fixing the SQL you will be able to run it…

P.S.
I would suggest to put on the end of script instead of “;” a “/” sign and place one more enter…this may a problem sometimes. If you do not have “;” then this is your problem.

Where is that option located in Toad 11.6.1.6?

Jonas Oglesby, Jr. | Sr. Finance Manager

O: 615.614.4114 – Jonas.Oglesby@Healthways.com

**Healthways, **a subsidiary of Sharecare, Inc.

Sharecare acquires Healthways’ Population Health Business ** Learn more**

From: Gregory Liss [mailto:bounce-GTDG@toadworld.com]

Sent: Monday, August 22, 2016 7:07 AM

To: toadoracle@toadworld.com

Subject: [External] RE: [Toad for Oracle - Discussion Forum] How to execute multiple SQL files using Automation Designer

RE: How to execute multiple SQL files using Automation Designer

Reply by Gregory Liss

Make sure this is unchecked.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.



This email contains confidential and proprietary information and is not to be used or disclosed to anyone other than the named recipient of this email, and is to be used only for the intended purpose of this communication.


That option didn’t appear until Toad 12. 11.6 is nearly 4 years (and 7 versions) old so it may be time to consider an upgrade.

From: Jayso [mailto:bounce-Jayso@toadworld.com]

Sent: Monday, August 22, 2016 11:27 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] How to execute multiple SQL files using Automation Designer

RE: How to execute multiple SQL files using Automation Designer

Reply by Jayso

Where is that option located in Toad 11.6.1.6?

Jonas Oglesby, Jr. | Sr. Finance Manager

O: 615.614.4114 – Jonas.Oglesby@Healthways.com

**Healthways, **a subsidiary of Sharecare, Inc.

Sharecare acquires Healthways’ Population Health Business ** Learn more**

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Thanks

Jonas Oglesby, Jr. | Sr. Finance Manager

O: 615.614.4114 – Jonas.Oglesby@Healthways.com

**Healthways, **a subsidiary of Sharecare, Inc.

Sharecare acquires Healthways’ Population Health Business ** Learn more**

From: Gregory Liss [mailto:bounce-GTDG@toadworld.com]

Sent: Monday, August 22, 2016 10:32 AM

To: toadoracle@toadworld.com

Subject: [External] RE: [Toad for Oracle - Discussion Forum] How to execute multiple SQL files using Automation Designer

RE: How to execute multiple SQL files using Automation Designer

Reply by Gregory Liss

That option didn’t appear until Toad 12. 11.6 is nearly 4 years (and 7 versions) old so it may be time to consider an upgrade.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.



This email contains confidential and proprietary information and is not to be used or disclosed to anyone other than the named recipient of this email, and is to be used only for the intended purpose of this communication.


The nice thing about the Automation Designer is that you can often times achieve desired results by other means. You can do what you want with the Shell Execute option.

In my example I have two scripts. The first runs with error, the second does not. I have 2 Shell Execute actions in my app, one for each script. I create a BAT file to execute my scripts using SQL*Plus. The bat file contents are…

echo exit | sqlplus user/pwd@db @%1

Each of my shell execute actions calls this BAT file and the parameter of the action specifies the script to execute.

Copy the text below and paste it into your automation designer. You’ll see one of the shell execute actions I created. Look at its properties and you’ll see how it’s called. If you just need to execute the scripts then do as I did and you’re done. If you need the output sent somewhere then you’ll have to do a little more work to spool output, etc., but that shouldn’t take too much work. When run in this way you don’t get any prompt on error and execution proceeds after error.

object TarShellExecute
Enabled = True
ID = 24
ParentID = 4
UserName = ‘Run Script with Error’
ActionSetID = 0
LastRunDate = 42604.490255046290000000
Executable = ‘C:\RunScript.bat’
IconIndex = 0
Parameters = ‘C:\Has_Error.sql’
RunMode = 5
WaitForTermination = True
WorkingDir = ‘C:’
RunData = {
545046300A54617252756E44617461025F310A416374696F6E4E616D65061552
756E205363726970742077697468204572726F720B416374696F6E5365744944
02040D416374696F6E5365744E616D650604417070310249440218084661696C
4D6F6465070A666D436F6E74696E75650752756E44617465050088CE5A817D6C
A60E400752756E55736572060541646D696E104D657373616765732E53747269
6E6773010646382F32322F323031362031313A34353A353820414D3A20205275
6E205363726970742077697468204572726F7220285368656C6C204578656375
74652920737461727465642E0647382F32322F323031362031313A34353A3538
20414D3A202052756E205363726970742077697468204572726F722028536865
6C6C2045786563757465292066696E69736865642E0006537461747573070961
73537563636573730000}
end