how to run a toad script in batch

Toad for IBM DB2
1

i need to run a simple toad script from the command line.

Thank you.

Al

2

I would suggest to create an Automation script - save that and schedule that to run.

You can then see the command line arguements to run a script file:

au1.jpeg
au1.jpeg1366×649 113 KB

Then save the automation script:

au2.jpeg

Then schedule that via:

au3.jpeg

Then you can see the command line syntax:

au4.jpeg

"E:\Program Files (x86)\Dell\Toad for DB2 2016 Suite\Toad for DB2 6.2\toad.exe" -batch=true "D:\Misc\SQL\aus1.tas"

You can see that -batch=true is the first parm

You can see that the tas (automation file) is the second parm

Hope this helps

3

fantastic! I will try it. Thanks, Al

On Mon, Sep 26, 2016 at 4:25 PM, Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com wrote:

RE: how to run a toad script in batch

Reply by Jeff Podlasek
I would suggest to create an Automation script - save that and schedule that to run.

You can then see the command line arguements to run a script file:

Then save the automation script:

Then schedule that via:

Then you can see the command line syntax:

"E:\Program Files (x86)\Dell\Toad for DB2 2016 Suite\Toad for DB2 6.2\toad.exe" -batch=true "D:\Misc\SQL\aus1.tas"

You can see that -batch=true is the first parm

You can see that the tas (automation file) is the second parm

Hope this helps

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

4

Hi Jeff,

thank you. I was able to schedule the task.

Do you have a list of the possible parameters for the exe?

Thank you.

Al

On Mon, Sep 26, 2016 at 4:25 PM, Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com wrote:

RE: how to run a toad script in batch

Reply by Jeff Podlasek
I would suggest to create an Automation script - save that and schedule that to run.

You can then see the command line arguements to run a script file:

Then save the automation script:

Then schedule that via:

Then you can see the command line syntax:

"E:\Program Files (x86)\Dell\Toad for DB2 2016 Suite\Toad for DB2 6.2\toad.exe" -batch=true "D:\Misc\SQL\aus1.tas"

You can see that -batch=true is the first parm

You can see that the tas (automation file) is the second parm

Hope this helps

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

5

Hi Jeff,

I was able to run a script using toad from the desktop. I tested running my script from toad and it produces a spreadsheet with five tabs. when I run it using the toad exec from the desktop, using your suggestion, it produces only two tabs.

Any thoughts?

Thanks a lot.

Best regards,

Al

On Mon, Sep 26, 2016 at 4:25 PM, Jeff Podlasek bounce-Jeff_Podlasek@toadworld.com wrote:

RE: how to run a toad script in batch

Reply by Jeff Podlasek
I would suggest to create an Automation script - save that and schedule that to run.

You can then see the command line arguements to run a script file:

Then save the automation script:

Then schedule that via:

Then you can see the command line syntax:

"E:\Program Files (x86)\Dell\Toad for DB2 2016 Suite\Toad for DB2 6.2\toad.exe" -batch=true "D:\Misc\SQL\aus1.tas"

You can see that -batch=true is the first parm

You can see that the tas (automation file) is the second parm

Hope this helps

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

6

I would recommend opening up a support case at

https://support.quest.com/productline/toad

That way the support tech’s can capture and track all necessary information.

7

Hi Jeff,

I have Toad 6.0 and 6.2 installed on my computer. I use mostly 6.0 (the bug of empty sql in automation script freezing the rest of the script is the reason).

In 6.0 the button of schedule automation does nothing. In 6.2 I get an error message ( in my local language) parameter error.

8

Thanks Jeff. There was a parameter error, but using your instructions I was able to manually add the tasks and they are now up and running. It was a great help to an acute problem.