SQL Task
Overview
The SQL task allows you to execute one or a series of SQL statements against the database specified in the task.
Note
Before you can run a SQL task, you first must create a Database Connection, which defines the information needed to locate and access the database.
Built-In Variables
The following built-in variables can be used in a SQL task to pass data where appropriate:
Creating a SQL Task
Step 1 | From the Automation Center navigation pane, select Tasks > SQL Tasks. The SQL Tasks list displays a list of all currently defined SQL tasks. |
|---|---|
Step 2 | Enter/select Details for a new SQL task, using the field descriptions below as a guide.
To display more of the Details fields on the screen, you can either:
|
Step 3 | Click the button. The task is added to the database, and all buttons and tabs in the Task Details are enabled. |
Note
To open an existing record on the list, either:
Click a record in the list to display its record Details below the list. (To clear record Details below the list, click the New button that displays above and below the Details.)
Clicking the Details icon next to a record name in the list, or right-click a record in the list and then click Open in the Action menu that displays, to display a pop-up version of the record Details.
Right-click a record in the a list, or open a record and right-click in the record Details, and then click Open In Tab in the Action menu that displays, to display the record Details under a new tab on the record list page (see Record Details as Tabs).
SQL Task Details
The following SQL Task Details is for an existing SQL task.
Depending on the values that you enter / select for these fields, and whether or not the SQL task has ever been launched, more (or less) fields may display. See the field descriptions, below, for a description of all fields that may display in the SQL Task Details.