Versions Compared

Old Version 3

changes.mady.by.user Stonebranch

Saved on

compared with

New Version 4

changes.mady.by.user Stonebranch

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
Creating a SQL Task
Creating a SQL Task

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.
 
To the right of list, SQL Task Details for a new SQL task displays.
 

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  button above the list to display a pop-up version of the Details.

Step 3

Click the  button. The task is added to the database, and all buttons and tabs in the Task Details are enabled.

...

Note
titleNote

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).

Anchor
SQL Task Details
SQL Task Details

SQL Task Details

The following SQL Task Details is for an existing SQL task.

...

Field Name

Description

General

This section contains general information about the task.

Name

Include Page
IL:Task Name
IL:Task Name

Version

Include Page
IL:Versions
IL:Versions

Description

Include Page
IL:Summary
IL:Summary

Member of Business Services

Include Page
IL:Member of Business Services
IL:Member of Business Services

Resolve Name Immediately

Include Page
IL:Resolve Name Immediately
IL:Resolve Name Immediately

Time Zone Preference

Include Page
IL:Time Zone Preference
IL:Time Zone Preference

Hold on Start

Include Page
IL:Hold on Start
IL:Hold on Start

Hold Reason

Include Page
IL:Hold Reason
IL:Hold Reason

Virtual Resource Priority

Include Page
IL:Virtual Resource Priority
IL:Virtual Resource Priority

Anchor
Hold Resources on Failure
Hold Resources on Failure
Hold Resources on Failure

Include Page
IL:Hold Resources on Failure
IL:Hold Resources on Failure

Mutually Exclusive With Self

Include Page
IL:Mutually Exclusive With Self
IL:Mutually Exclusive With Self

Simulate 
Include Page
IL:Simulate
IL:Simulate

SQL Details

This section contains assorted detailed information about the task.

Anchor
Database Connection
Database Connection
Database Connection

Include Page
IL:Database Connection Field - 6.4.2
IL:Database Connection Field - 6.4.2

Anchor
Database Connection Variable
Database Connection Variable
Database Connection Variable

Include Page
IL:Database Connection Variable
IL:Database Connection Variable

Anchor
Credentials
Credentials
Credentials

Include Page
IL:Credentials field - SQL
IL:Credentials field - SQL

Credentials Variable

Include Page
IL:Credentials Variable
IL:Credentials Variable

Maximum Rows

Include Page
IL:Maximum Rows - 6.4.3.0
IL:Maximum Rows - 6.4.3.0

Auto Cleanup

Include Page
IL:Auto Cleanup
IL:Auto Cleanup

SQL Command

Include Page
IL:SQL Command
IL:SQL Command

Result Processing DetailsThis section contains assorted detailed information about result processing for this task.

Anchor
Result Processing
Result Processing
Result Processing

Include Page
IL:Result Processing
IL:Result Processing

Anchor
Exit Codes
Exit Codes
Exit Codes

Include Page
IL:Exit Codes-Result Processing
IL:Exit Codes-Result Processing

Anchor
Column Name
Column Name
Column Name

Include Page
IL:Column Name
IL:Column Name

Anchor
Operator
Operator
Operator

Include Page
IL:Operator
IL:Operator

Anchor
Value
Value
Value

Include Page
IL:Value
IL:Value

Retry Options

This section contains specifications for retrying the task.

Anchor
Maximum Retries
Maximum Retries
Maximum Retries

Include Page
IL:Maximum Retries
IL:Maximum Retries

Retry Indefinitely

Include Page
IL:Retry Indefinitely
IL:Retry Indefinitely

Retry Interval (Seconds)

Include Page
IL:Retry Interval
IL:Retry Interval

Suppress Intermediate Failures

Include Page
IL:Suppress Intermediate Failures
IL:Suppress Intermediate Failures

Wait / Delay Options

This section contains specifications for waiting to start and/or delaying on start the task.

Anchor
Wait To Start
Wait To Start
Wait To Start

Include Page
IL:Wait To Start - 6.2.1.0
IL:Wait To Start - 6.2.1.0

Anchor
Wait Time
Wait Time
Wait Time

Include Page
IL:Wait Time - 6.2.1.0
IL:Wait Time - 6.2.1.0

Anchor
Wait Day Constraint
Wait Day Constraint
Wait Day Constraint

Include Page
IL:Wait Day Constraint
IL:Wait Day Constraint

Anchor
Wait Duration
Wait Duration
Wait Duration

Include Page
IL:Wait Duration
IL:Wait Duration

Anchor
Wait Duration In Seconds
Wait Duration In Seconds
Wait Duration In Seconds

Include Page
IL:Wait Duration In Seconds
IL:Wait Duration In Seconds

Anchor
Delay On Start
Delay On Start
Delay On Start

Include Page
IL:Delay On Start
IL:Delay On Start

Anchor
Delay Duration
Delay Duration
Delay Duration

Include Page
IL:Delay Duration
IL:Delay Duration

Anchor
Delay Duration In Seconds
Delay Duration In Seconds
Delay Duration In Seconds

Include Page
IL:Delay Duration In Seconds
IL:Delay Duration In Seconds

Anchor
Workflow Only
Workflow Only
Workflow Only

Include Page
IL:Workflow Only
IL:Workflow Only

Time Options

This section contains time-related specifications for the task.

Anchor
Late Start
Late Start
Late Start

Include Page
IL:Late Start
IL:Late Start

Anchor
Late Start Type
Late Start Type
Late Start Type

Include Page
IL:Late Start Type
IL:Late Start Type

Anchor
Late Start Time
Late Start Time
Late Start Time

Include Page
IL:Late Start Time
IL:Late Start Time

Anchor
Late Start Day Constraint
Late Start Day Constraint
Late Start Day Constraint

Include Page
IL:Late Start Day Constraint
IL:Late Start Day Constraint

Anchor
Late Start Nth Amount
Late Start Nth Amount
Late Start Nth Amount

Include Page
IL:Late Start Nth Amount
IL:Late Start Nth Amount

Anchor
Late Start Duration
Late Start Duration
Late Start Duration

Include Page
IL:Late Start Duration - NEW
IL:Late Start Duration - NEW

Anchor
Late Finish
Late Finish
Late Finish

Include Page
IL:Late Finish
IL:Late Finish

Anchor
Late Finish Type
Late Finish Type
Late Finish Type

Include Page
IL:Late Finish Type
IL:Late Finish Type

Anchor
Late Finish Offset Type
Late Finish Offset Type
Late Finish Offset Type

Include Page
IL:Late Finish Offset Type
IL:Late Finish Offset Type

Anchor
Late Finish Percentage Offset ( + )
Late Finish Percentage Offset ( + )
Late Finish Percentage Offset ( + )

Include Page
IL:Late Finish Percentage Offset ( + )
IL:Late Finish Percentage Offset ( + )

Anchor
Late Finish Duration Offset ( + )
Late Finish Duration Offset ( + )
Late Finish Duration Offset ( + )

Include Page
IL:Late Finish Duration Offset ( + )
IL:Late Finish Duration Offset ( + )

Anchor
Late Finish Duration Offset Unit
Late Finish Duration Offset Unit
Late Finish Duration Offset Unit

Include Page
IL:Late Finish Duration Offset Unit
IL:Late Finish Duration Offset Unit

Anchor
Late Finish Time
Late Finish Time
Late Finish Time

Include Page
IL:Late Finish Time
IL:Late Finish Time

Anchor
Late Finish Day Constraint
Late Finish Day Constraint
Late Finish Day Constraint

Include Page
IL:Late Finish Day Constraint
IL:Late Finish Day Constraint

Anchor
Late Finish Nth Amount
Late Finish Nth Amount
Late Finish Nth Amount

Include Page
IL:Late Finish Nth Amount
IL:Late Finish Nth Amount

Anchor
Late Finish Duration
Late Finish Duration
Late Finish Duration

Include Page
IL:Late Finish Duration - NEW
IL:Late Finish Duration - NEW

Anchor
Early Finish
Early Finish
Early Finish

Include Page
IL:Early Finish
IL:Early Finish

Anchor
Early Finish Type
Early Finish Type
Early Finish Type

Include Page
IL:Early Finish Type
IL:Early Finish Type

Anchor
Early Finish Offset Type
Early Finish Offset Type
Early Finish Offset Type

Include Page
IL:Early Finish Offset Type
IL:Early Finish Offset Type

Anchor
Early Finish Percentage Offset ( - )
Early Finish Percentage Offset ( - )
Early Finish Percentage Offset ( - )

Include Page
IL:Early Finish Percentage Offset ( - )
IL:Early Finish Percentage Offset ( - )

Anchor
Early Finish Duration Offset ( - )
Early Finish Duration Offset ( - )
Early Finish Duration Offset ( - )

Include Page
IL:Early Finish Duration Offset ( - )
IL:Early Finish Duration Offset ( - )

Anchor
Early Finish Duration Offset Unit
Early Finish Duration Offset Unit
Early Finish Duration Offset Unit

Include Page
IL:Early Finish Duration Offset Unit
IL:Early Finish Duration Offset Unit

Anchor
Early Finish Time
Early Finish Time
Early Finish Time

Include Page
IL:Early Finish Time
IL:Early Finish Time

Anchor
Early Finish Day Constraint
Early Finish Day Constraint
Early Finish Day Constraint

Include Page
IL:Early Finish Day Constraint
IL:Early Finish Day Constraint

Anchor
Early Finish Nth Amount
Early Finish Nth Amount
Early Finish Nth Amount

Include Page
IL:Early Finish Nth Amount
IL:Early Finish Nth Amount

Anchor
Early Finish Duration
Early Finish Duration
Early Finish Duration

Include Page
IL:Early Finish Duration - NEW
IL:Early Finish Duration - NEW

Anchor
User Estimated Duration
User Estimated Duration
User Estimated Duration

Include Page
IL:User Estimated Duration
IL:User Estimated Duration

Critical Path Options

This section contains Critical Path-related specifications for the task.

Anchor
CP Duration
CP Duration
CP Duration

Include Page
IL:CP Duration
IL:CP Duration

Anchor
CP Duration (Resolved)
CP Duration (Resolved)
CP Duration (Resolved)

Include Page
IL:CP Duration (Resolved)
IL:CP Duration (Resolved)

Anchor
CP Duration Unit
CP Duration Unit
CP Duration Unit

Include Page
IL:CP Duration Unit
IL:CP Duration Unit

Workflow Execution Options

This section contains Execution Restriction specifications for the task if it is within a Workflow.

Anchor
Execution Restriction
Execution Restriction
Execution Restriction

Include Page
IL:Execution Restriction
IL:Execution Restriction

Anchor
Restriction Period
Restriction Period
Restriction Period

Include Page
IL:Restriction Period
IL:Restriction Period

Anchor
Before Date
Before Date
Before Date

Include Page
IL:Before Date
IL:Before Date

Anchor
Before Time
Before Time
Before Time

Include Page
IL:Before Time
IL:Before Time

Anchor
After Date
After Date
After Date

Include Page
IL:After Date
IL:After Date

Anchor
After Time
After Time
After Time

Include Page
IL:After Time
IL:After Time

Anchor
Date List
Date List
Date List

Include Page
IL:Date List
IL:Date List

Statistics

This section contains time-related statistics for task instances of the task.

First Execution

Include Page
IL:First Execution
IL:First Execution

Last Execution

Include Page
IL:Last Execution
IL:Last Execution

Last Instance Duration

Include Page
IL:Last Instance Duration
IL:Last Instance Duration

Lowest Instance Time

Include Page
IL:Lowest Instance Time
IL:Lowest Instance Time

Average Instance Time

Include Page
IL:Average Instance Time
IL:Average Instance Time

Highest Instance Time

Include Page
IL:Highest Instance Time
IL:Highest Instance Time

Number of Instances

Include Page
IL:Number of Instances
IL:Number of Instances

Metadata

This section contains Metadata information about this record.

UUID

Universally Unique Identifier of this record.

Updated By

Name of the user that last updated this record.

Updated

Date and time that this record was last updated.

Created By

Name of the user that created this record.

Created

Date and time that this record was created.

Buttons

This section identifies the buttons displayed above and below the Task Details that let you perform various actions.

Save

Saves a new task record in the Controller database.

Save & New

Saves a new record in the Controller database and redisplays empty Details so that you can create another new record.

Save & View

Saves a new record in the Controller database and continues to display that record.

New

Displays empty (except for default values) Details for creating a new task.

Update

Include Page
IL:Update button
IL:Update button

Launch Task

Include Page
IL:Launch Task button
IL:Launch Task button

View Parents

Include Page
IL:View Parents button
IL:View Parents button

Copy

Creates a copy of this task, which you are prompted to rename.

Delete

Include Page
IL:Delete button
IL:Delete button

Note
titleNote

You cannot delete a task if it is either:

  • Specified in an enabled Trigger.
  • The only task specified in a disabled Trigger.


Refresh

Refreshes any dynamic data displayed in the Details.

Close

For pop-up view only; closes the pop-up view of this task.

Tabs

This section identifies the tabs across the top of the Task Details that provide access to additional information about the task.

Variables

Include Page
IL:Variables tab
IL:Variables tab

Actions

Include Page
IL:Actions tab
IL:Actions tab

Virtual Resources

Include Page
IL:Task Virtual Resources tab - 6.7.0.0
IL:Task Virtual Resources tab - 6.7.0.0

Mutually Exclusive

Include Page
IL:Mutually Exclusive Tasks tab
IL:Mutually Exclusive Tasks tab

Anchor
Instances tab
Instances tab
Instances

Lists all instances of the task.

Triggers

Include Page
IL:Triggers tab
IL:Triggers tab

Notes

Include Page
IL:Notes tab
IL:Notes tab

Anchor
Versions tab
Versions tab
Versions

Include Page
IL:Versions tab
IL:Versions tab

Anchor
Viewing a SQL Task Instance
Viewing a SQL Task Instance

Viewing a SQL Task Instance

When a SQL task is launched, the Controller creates a task instance record of that task.

...

Anchor
SQL Task Instance Details
SQL Task Instance Details

SQL Task Instance Details

The following SQL Task Instance Details contains information on the execution of a SQL task.
 

...