Project

General

Profile

SQLAction Extender

Function


The extender performs SQL queries or scripts.

Add_new_step_of_type_Execute_SQL_query.png

Name for new step – user name of the task.

1. SQL query
This group of parameters specifies execution of either specified query or a selected file of the script. If both parameters are specified, only the query will be executed.
2. SQL parameters
Separator – specifies a set of symbols that serve as a divider between queries in the script file. Default value is GO. The script file must contain line break symbols after each divider.
Command timeout – the period (in seconds) after which, if the query has not been executed yet, a respective exception will be displayed and an error entry will be created. In case of scripts, this time period is applicable to each separate query not to all queries of the script as a whole.
3. Connection to DB
In this group, you can specify whether or not standard line of connection to DB will be used. Alternatively, you can specify it.

Add picture from clipboard (Maximum size: 742 MB)