Script/File Execution Facilities

Go Up to Tools

The following two stand-alone utilities establish multiple threads and database connections, letting you simultaneously execute SQL statements against multiple cross-DBMS platform datasources:

• Script Execution Facility. Lets you type or paste SQL statements that you want to execute.
• File Execution Facility. Lets you load files containing SQL statements that you want to execute.

Both utilities work in conjunction with supported scheduling facilities, letting you schedule execution jobs. After completing a scheduled job, a results report lists errors, verifies script execution, and details the output of the job. You can set it so that it sends results to any e-mail or network recipient.

Both utilities use a tabbed dialog box where you set the parameters and options for the script execution.

To execute SQL using one of these facilities

1. On the Tools menu, select either Script Execution Facility or File Execution Facility. A tabbed dialog opens, letting you provide the SQL code you want executed along with additional details.
2. Use the following table as a guide to the available settings in this dialog, and then click Execute when done:

Tab	Setting	Description
Script (Script Execution Facility only)	Script box	Lets you type or paste a script.
Files (File Execution Facility only)	Show Full File Paths	Select to display the full path. Deselect to display only the file name.
	File Name	Displays the file names.
	Add and Remove	Use these controls to add or remove files.
	View	Opens the View File dialog box.
	Up and Down	Use these controls to move the selected file up or down in the list.
Target	Select the Target Datasource(s) to Execute the Script Against	Only Connected Datasources - Displays only datasources that are currently connected in the Datasource grid. All DBMS Types - Displays all DBMS types in the Datasource grid.
	Datasource grid	Displays the target datasource(s) to execute the script/file against. Select a datasource name. If the datasource has multiple databases, type in a database in the Database box.
Output	Graphical Output	If selected, specifies a graphical output.
	File Output	If selected, specifies a file output. Directory - Type or browse to enter the full path and directory name in which you want to place the output file. File Type - Specifies a file type. Include column titles when saving - If selected, lets you save column titles. Open files with registered applications - If selected, opens files with registered applications.
Notify	Job Description	Lets you enter a job description. This description will be the subject of the notification E-mail.
	E-mail address	Lets you enter E-mail addresses. Separate each E-mail address with a semicolon (;).
	Net Send User Names	Lets you enter net send user names. Separate each name with a semicolon (;).