Automation simplifies life – until that script fails to run. All these processes are stuck in the “log jam”, with the problem waiting to be determined and cleared. In this blog, the following tips and procedures will assist one in troubleshooting Automation Script problems when a script does not run when scheduled.
In this blog installment, the following troubleshooting techniques are covered:
Toad Data Point allows you to schedule an Automation script. Scripts are scheduled and managed by the Job Manager.You can automatically send your script file name and other information to the Job Manager by clicking Schedule in the Wizard bar.
When you schedule an Automation script in Toad, a Windows scheduled task is created.You can also manage an Automation script as a scheduled task from the Windows Task Scheduler.
AUTOMATION TROUBLESHOOTING CHECKLIST
Watch a video, Troubleshooting scheduled Automation scripts in Toad Data Point, which highlights these checklist points.
Running Automation Scripts on a Server
If you run Toad Data Point on a server and run scheduled Automation scripts, you must log-in and create connections once.
General Troubleshooting Tips
The instance of Toad used to run a scheduled script must be able to launch unattended. Disable any prompts that display on the initial launch of Toad and also require user interaction to close.
Troubleshoot Using Error Email
If your script runs, but there is an error during execution, you can instruct your script to send you an email notification. It is a good idea to configure this option for all your scripts.
Troubleshoot Scripts Using the Job Manager
Note: This method does not apply to scripts running in Toad Intelligence Central. See Manage Automation Scripts in Intelligence Central for more information.
To begin troubleshooting your script, open the Job Manager and review the script properties.
Open Job Manager
View Task Properties
Ensure Task Runs When Logged Off
In the task properties dialog, in the Task tab, deselect the Run only if logged on option. This ensures that Toad will run even if you are logged off.
Ensure Task Runs on Weekends
If you scheduled a script to run daily, and you find that the script is not running on the weekends, try this workaround.
Instruct Windows to Wake to Run Script
Use this tip to wake the computer from a power-saving mode to run your scheduled task.
Update Windows Password
Depending on your version of Windows, if you changed your Windows password, you may also need to update the password in each of your scheduled tasks.
Troubleshoot Scripts Using the Windows Task Scheduler
If the preceding tips did not correct the issue and your script still does not run when scheduled, you can use the Windows Task Scheduler to check for other task-related issues.
Open Windows Task Scheduler
Tip: Click Refresh in the Actions pane to refresh the window after adding or deleting scheduled tasks using Toad.
Review Error Codes
Review the following error codes for more information.
The script executed successfully.
There was an error during script execution and the script terminated.
Decimal equivalent: 999.
There was an error during script execution and the script continued to run.
Tip: If the script continued on an error, one of the following settings is specified in the script:
o The Continue On Error option is selected for the script.
o The Stop on error option is deselected for an activity.
Decimal equivalent: 111
The Trial license key for this instance of Toad expired. Enter a Commercial license key.
Decimal equivalent: 555
Error codes other than those described above, indicate that the script did not start. For example, if the path to Toad is incorrect in the scheduled task, then the script will not start.
Confirm Toad Application and Script File Locations for a Task
Confirm that the path to the Toad executable and the path to the script file are correct.
Configure Task Scheduler to Send Email on Error
In some versions of Windows, you can configure the Task Scheduler to send an email if your scheduled task doesn't run.
Note: This allows you to receive an email notification if the task doesn't run as scheduled. To receive email notification of an error during script execution, specify this option within your Automation script. See Troubleshoot Using Error Email for more information.
Troubleshoot Using Automation Script Logs
If your script runs, but there is an issue during execution, you can review the script log to help identify the issue.
Note: For scripts running in Intelligence Central, open the Script Manager. See Manage Automation Scripts in Intelligence Central.
Note: If you use the Verbose option, Toad generates an additional log file just for email errors. The name of this log file is MailBee_.txt and it can provide you with information about your email errors.
Further valuable Toad Data Point resources are available at Toad World.