Toad Data Point 6.1.2

Welcome to Toad Data Point Understand Toad's Workflow

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Upgrade Automation Scripts and Scheduling Tasks

If you upgrade to a newer version of Toad, Automation scripts created in a previous version must be upgraded before you can open them in the newer version. Toad prompts you to automatically upgrade a script when you attempt to open it in a newer version.

In addition, scheduled scripts are scheduled to run using the version of Toad in which they were created. After upgrading Toad, those previously-created, scheduled scripts will not execute in the newer version until you migrate each script's scheduling task. Toad prompts you to migrate scheduling tasks when you initially launch the application after installation.

Note: If Toad was installed with the Prohibit saving passwords option selected, the Automation module is disabled and Toad does not prompt you to migrate scripts.

Upgrade Automation Scripts to Newer Version of Toad

An automation script is compatible with the version of Toad in which the script was created. If you want to open and/or modify a script using a newer version of Toad, you must upgrade the script. Toad automatically prompts you to upgrade the script the first time you open it in the newer version.

To upgrade an Automation script

Open the script in Toad. Toad prompts you to upgrade the script.
To upgrade the script, select Yes.

Caution: If you upgrade an automation script, it will no longer be compatible with earlier versions of Toad.
Select No (and do not elect to save the script), to keep the script compatible with the previous version.
If you selected Yes, Toad upgrades your script and saves a backup copy of the original script in the following location:

<application data directory>\Automation\bak\
If the script you upgraded is also scheduled, you must migrate the scheduling task, otherwise the upgraded script will fail to run.
Be sure the Toad Data Point version used for creating and publishing an automation script to TIC is the same version of Toad Data Point installed on the Toad Intelligence Central Server machine where the created automation script will be run.

Migrate Scheduling Tasks to Newer Version of Toad

Each scheduled Automation script uses a Windows scheduling task. The scheduling task specifies which version of Toad to use by specifying the version's application path. Toad provides you with two easy ways to migrate your scheduled scripts' scheduling tasks when you upgrade Toad. First, Toad prompts you to migrate scheduling tasks upon initial launch of the application after installation. Next, you can migrate scheduling tasks at any time using the Job Manager.

Notes:

If you upgrade a previously-created script by opening it in a newer version of Toad, you must also migrate the scheduling task to the newer version.
If you install the newer version of Toad side-by-side with the older version, previously-created, scheduled scripts will continue to execute using the older version, until you migrate the scheduling tasks (provided that you do not open the scripts in the newer version).

To migrate scheduling tasks upon initial launch

After upgrading Toad, and upon initial launch of the application, the Migrate Scheduled Tasks dialog opens.
Select the scheduled tasks (scheduled Automation scripts) to migrate to the new version of Toad.
Click OK to close the dialog.
Toad immediately prompts you for your Windows password. Enter your password to migrate the scheduled tasks.

To migrate scheduling tasks using the Job Manager

Select Tools | Administer | Job Manager.
Click on the Job Manager toolbar.
Select the scheduled tasks to migrate and click OK.

Note: Only currently-scheduled tasks (enabled or disabled) are listed in the Migrate Scheduled Tasks dialog.
Toad immediately prompts you for your Windows password. Enter your password to migrate the scheduled tasks.

Manually Edit Scheduling Tasks

On occasion you may need to modify the application path in a Windows scheduling task. You can do this by manually editing the scheduling task using the following procedure.

To manually edit a scheduling task

In the Job Manager (Tools | Administer | Job Manager), right-click a task and select Edit Task.
To change the version of Toad used to run the script, in the Actions tab, change the folder name in the toad.exe path.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 6.1.2 - User Guide

Upgrade Automation Scripts and Scheduling Tasks

Upgrade Automation Scripts to Newer Version of Toad

Migrate Scheduling Tasks to Newer Version of Toad

Manually Edit Scheduling Tasks