Is it possible to call a Toad automation from outside of Toad?

[jraguse]

We have several Toad automations that are scheduled to run at various times throughout the day and are published to Toad Intelligence Central (TIC). These automations "push" reports with information to employees based on the schedule that we have set up. Some of these employees would also like the option to "pull" the reports on an adhoc basis - in other words at a time that is not already scheduled. For security reasons, we don't wish to give Toad access to all employees.

I guess what we are wondering, is it possible to send a set of instructions to the server where Toad Intelligence Central resides that would immediately run an automation that is already installed within TIC? The set of instructions would need to come from an employee that does not have access to Toad.

I figure that with all of the Toad users out there, that this question has already been addressed, but I didn't locate an answer yet on Toad World.

Thanks for your help.

[Debbie_Peabody]

No, we don’t really have anything like that right now. You need to run the Admin Console or Toad Data point and use the Run Script action.

Underneath the hood we are using the command line to kick off TDP and the automation script. If you want to go to that level I suppose you could use that but then the user would need to have access to the server. And I doubt that you want them to have that access either.

In the future we plan to add a run script to the Web App. This sounds like what you need. You would only need to give them a log id and privs to run the script he wants to run.

Debbie

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

Sent: Friday, February 12, 2016 8:54 AM

To: toadintelligencecentral@toadworld.com

Subject: [Toad Intelligence Central - General Discussion] Is it possible to call a Toad automation from outside of Toad?

Is it possible to call a Toad automation from outside of Toad?

Thread created by jraguse

We have several Toad automations that are scheduled to run at various times throughout the day and are published to Toad Intelligence Central (TIC). These automations “push” reports with information to employees based on the schedule that we have set up. Some of these employees would also like the option to “pull” the reports on an adhoc basis - in other words at a time that is not already scheduled. For security reasons, we don’t wish to give Toad access to all employees.

I guess what we are wondering, is it possible to send a set of instructions to the server where Toad Intelligence Central resides that would immediately run an automation that is already installed within TIC? The set of instructions would need to come from an employee that does not have access to Toad.

I figure that with all of the Toad users out there, that this question has already been addressed, but I didn’t locate an answer yet on Toad World.

Thanks for your help.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Intelligence Central - General notifications altogether.

Flag
this post as spam/abuse.

[jraguse]

Debbie,

Thank you for your response. The Web App idea does sound like it might work for us.

Could you give me a little more background on the Web App? Does this already exist, or is this still in development? Also, do you have any idea as to when the run script might be added to the Web App?

[nbrazz]

Any chance there is any update for this?

I built an automation that imports a spreadsheet to a table, and then runs a query off of that updated table and exports out of excel. From all my research, I either have to keep my computer on, or purchase the Server package? We do have VisualChron which I was hoping to utilize.

Thank you,

Nick

[Gavin.Lin_40186]

hi Nick,

You can first to get the CLI(command line interface) command to run your script. Then schedule the command with VisualChron.

How to get the command:

1. Open TDP(Toad Data Point) and try to create a new automation.

2. In the creating automation UI, you will find the Schedule button which is on the rigth bottom corner.

3. Click the Schedule button, switch to Action tab in the popup window.

4. Double click the item listed in the Action tab will popup the Edit Action window.

5. You will find the location of TDP and the arguments to run the script. Just replace the location of TDP and script with your own one. That’s the command to run the automation in CLI.

[Debbie_Peabody]

To run a Toad Data Point automation script with another scheduler use the following command line. -batch=true is what makes it run in silent mode.

c:…\Toad.exe -batch=true “%Path to automationscript%\Script_1.tas”

[nbrazz]

Good morning,

I am still trying to schedule the TOAD Automation within the system but I am facing some errors:

1. The Automation Files is on an encrypted area
2. so I saved it to my desktop
3. I zip the file through “Box Sync”. This seems to cause an issue as well
4. I pointed the export file to my desktop and it worked
5. When I schedule, I get an error, but when I right click on the scheduled task on the job manager and click run, it works.

The error I get in the log is:

New exception: 7/10/2017 8:00:02 AM

System.ComponentModel.Win32Exception: Access is denied

Stack trace:

Outer exception:

System.InvalidOperationException: Cannot open Service Control Manager on computer ‘HR11-013’. This operation might require other privileges.

Stack trace:

at System.ServiceProcess.ServiceController.GetDataBaseHandleWithAccess(String machineName, Int32 serviceControlManaqerAccess)

at System.ServiceProcess.ServiceController.GetDataBaseHandleWithEnumerateAccess(String machineName)

at System.ServiceProcess.ServiceController.GetServicesOfType(String machineName, Int32 serviceType)

at Quest.Toad.SqlServer.ServiceManager.ServiceData.GetSqlServerServices(String machineName)

at Quest.Toad.ConnectionManager.SqlServerConnectMediator.GetHostNameDefault()

at Quest.Toad.ConnectionManager.SqlServerConnectMediator.HostNameCompleteForDisplayMethod(String hostName)

at Quest.Toad.ConnectionManager.SqlServerConnectMediator.DescriptionLongMethod(String hostName, String userName, String databaseName)

at Quest.Toad.ConnectionManager.SqlServerConnectMediator.get_DescriptionLong()

at Quest.Toad.ConnectionManager.ConnectMediator.Initialize()

at Quest.Toad.ConnectionManager.SqlServerConnectMediator…ctor()

Outer exception:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.

Stack trace:

Nick Braciszewski

HRIS Data Analyst | Information Management

Division of Human Resources | University of Pennsylvania

3401 Walnut St., Suite 527a | Philadelphia, PA 19104

215-898-1318 Office |

nbrac@upenn.edu | www.hr.upenn.edu

The information contained in this email message is intended only for the personal and confidential use of the intended recipient. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by email, and delete the original message.

From: Gavin.Lin_40186 [mailto:bounce-GavinLin_40186@toadworld.com]

Sent: Friday, July 7, 2017 4:25 AM

To: toadintelligencecentral@toadworld.com

Subject: RE: [Toad Intelligence Central - General Discussion] Is it possible to call a Toad automation from outside of Toad?

RE: Is it possible to call a Toad automation from outside of Toad?

Reply by Gavin.Lin_40186

hi Nick,

You can first to get the CLI(command line interface) command to run your script. Then schedule the command with VisualChron.

How to get the command:

1. Open TDP(Toad Data Point) and try to create a new automation.

2. In the creating automation UI, you will find the Schedule button which is on the rigth bottom corner.

3. Click the Schedule button, switch to Action tab in the popup window.

4. Double click the item listed in the Action tab will popup the Edit Action window.

5. You will find the location of TDP and the arguments to run the script. Just replace the location of TDP and script with your own one. That’s the command to run the automation in CLI.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Intelligence Central Forum notifications altogether.

Flag
this post as spam/abuse.

[Debbie_Peabody]

I don’t recognize the error stack.

Are you using the “-batch=true” command arg?

Also, do you have a SQL Server connection that is set to automatically start on startup? If so, try turning off the auto connect.

[nbrazz]

Well this whole automation I am running is currently WITHIN TOAD.

This only occurs when I schedule the automation. If I push it out, it works. BUT it only works when my automation and import portion of the automation is local. When it has to reach out to a shared drive, and zip the end result in Box Sync, I also find this error.

Thanks!

Nick Braciszewski

HRIS Data Analyst | Information Management

Division of Human Resources | University of Pennsylvania

3401 Walnut St., Suite 527a | Philadelphia, PA 19104

215-898-1318 Office |

nbrac@upenn.edu | www.hr.upenn.edu

The information contained in this email message is intended only for the personal and confidential use of the intended recipient. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by email, and delete the original message.

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Monday, July 10, 2017 12:32 PM

To: toadintelligencecentral@toadworld.com

Subject: RE: [Toad Intelligence Central - General Discussion] Is it possible to call a Toad automation from outside of Toad?

RE: Is it possible to call a Toad automation from outside of Toad?

Reply by Debbie Peabody

I don’t recognize the error stack.

Are you using the “-batch=true” command arg?

Also, do you have a SQL Server connection that is set to automatically start on startup? If so, try turning off the auto connect.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Intelligence Central Forum notifications altogether.

Flag
this post as spam/abuse.

[Debbie_Peabody]

Can you open a support case and also include the automation script and full log file when run scheduled?