I am still trying to schedule the TOAD Automation within the system but I am facing some errors:
- The Automation Files is on an encrypted area
- so I saved it to my desktop
- I zip the file through “Box Sync”. This seems to cause an issue as well
- I pointed the export file to my desktop and it worked
- 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
System.InvalidOperationException: Cannot open Service Control Manager on computer ‘HR11-013’. This operation might require other privileges.
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.HostNameCompleteForDisplayMethod(String hostName)
at Quest.Toad.ConnectionManager.SqlServerConnectMediator.DescriptionLongMethod(String hostName, String userName, String databaseName)
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
HRIS Data Analyst | Information Management
Division of Human Resources | University of Pennsylvania
3401 Walnut St., Suite 527a | Philadelphia, PA 19104
215-898-1318 Office |
firstname.lastname@example.org | 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
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
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:
Open TDP(Toad Data Point) and try to create a new automation.
In the creating automation UI, you will find the Schedule button which is on the rigth bottom corner.
Click the Schedule button, switch to Action tab in the popup window.
Double click the item listed in the Action tab will popup the Edit Action window.
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.
Unsubscribe from Toad Intelligence Central Forum notifications altogether.
this post as spam/abuse.