...
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.
Below To the right of list, SQL Task Details for a new SQL task displays.
 Image Added
 Image Removed
|
|---|
Step 2 | Enter/select Details for a new SQL task, using the field descriptions below as a guide. - Required fields display an asterisk ( * ) after the field name.
- Default values for fields, if available, display automatically.
To display more of the Details fields on the screen, you can either: - Use the scroll bar.
- Temporarily hide the list above the Details.
- Click the New button
 Image Added button above the list to display a pop-up version of the Details.
|
|---|
Step 3 | a Save buttonthe Image Added 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).
|
...
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.
Image Removed
Image Added
SQL Task Details Field Descriptions
...
The following SQL Task Instance Details contains information on the execution of a SQL task.
Image Removed
Image Added
SQL Task Instance Details Field Descriptions
...