Versions Compared

Key

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

...

Creating a Stored Procedure Task

Step 1

From the Automation Center navigation pane, select Tasks > Stored Procedure Tasks. The Stored Procedure Tasks list displays a list of all currently defined Stored Procedure tasks.
 
Below the list, Stored Procedure Task Details for a new Stored Procedure task displays.
 

Step 2

Enter/select Details for a new Stored Procedure 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 above the list to display a pop-up version of the Details.

Step 3

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

...

Field Name

Description

General

This section contains general information about the task.

Name

Include Page
UC69IL:Task NameUC69
IL:Task Name

Version

Include Page
UC69IL:VersionsUC69
IL:Versions

Description

Include Page
UC71xIL:SummaryUC71x
IL:Summary

Member of Business Services

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

Resolve Name Immediately

Include Page
UC69IL:Resolve Name ImmediatelyUC69
IL:Resolve Name Immediately

Time Zone Preference

Include Page
UC69IL:Time Zone PreferenceUC69
IL:Time Zone Preference

Hold on Start

Include Page
UC69IL:Hold on StartUC69
IL:Hold on Start

Hold Reason

Include Page
UC69IL:Hold ReasonUC69
IL:Hold Reason

Virtual Resource Priority

Include Page
UC69IL:Virtual Resource PriorityUC69
IL:Virtual Resource Priority

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

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

Stored Procedure Details

This section contains assorted detailed information about the task.

Anchor
Database Connection
Database Connection
Database Connection

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

Database Connection Variable

Include Page
UC69IL:Database Connection VariableUC69
IL:Database Connection Variable

Anchor
Credentials
Credentials
Credentials

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

Credentials Variable

Include Page
UC69IL:Credentials VariableUC69
IL:Credentials Variable

Maximum Rows

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

Auto Cleanup

Include Page
UC69IL:Auto CleanupUC69
IL:Auto Cleanup

Stored Procedure Name

Include Page
UC69IL:Stored Procedure NameUC69
IL:Stored Procedure Name

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

Anchor
Result Processing
Result Processing
Result Processing

Include Page
UC69IL:Result Processing-Stored ProcedureUC69
IL:Result Processing-Stored Procedure

Anchor
Exit Codes
Exit Codes
Exit Codes

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

Anchor
Parameter Position
Parameter Position
Parameter Position

Include Page
UC69IL:Parameter PositionUC69
IL:Parameter Position

Anchor
Column Name
Column Name
Column Name

Include Page
UC69IL:Column NameUC69
IL:Column Name

Anchor
CN Operator
CN Operator
Operator

Include Page
UC69IL:OperatorUC69
IL:Operator

Anchor
CN Value
CN Value
Value

Include Page
UC69IL:ValueUC69
IL:Value

Retry Options

This section contains specifications for retrying the task.

Anchor
Maximum Retries
Maximum Retries
Maximum Retries

Include Page
UC69IL:Maximum RetriesUC69
IL:Maximum Retries

Retry Indefinitely

Include Page
UC69IL:Retry IndefinitelyUC69
IL:Retry Indefinitely

Retry Interval (Seconds)

Include Page
UC69IL:Retry IntervalUC69
IL:Retry Interval

Suppress Intermediate Failures

Include Page
UC69IL:Suppress Intermediate FailuresUC69
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
UC69IL:Wait To Start - 6.2.1.0UC69
IL:Wait To Start - 6.2.1.0

Anchor
Wait Time
Wait Time
Wait Time

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

Anchor
Wait Day Constraint
Wait Day Constraint
Wait Day Constraint

Include Page
UC69IL:Wait Day ConstraintUC69
IL:Wait Day Constraint

Anchor
Wait Duration
Wait Duration
Wait Duration

Include Page
UC69IL:Wait DurationUC69
IL:Wait Duration

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

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

Anchor
Delay On Start
Delay On Start
Delay On Start

Include Page
UC69IL:Delay On StartUC69
IL:Delay On Start

Anchor
Delay Duration
Delay Duration
Delay Duration

Include Page
UC69IL:Delay DurationUC69
IL:Delay Duration

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

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

Anchor
Workflow Only
Workflow Only
Workflow Only

Include Page
UC69IL:Workflow OnlyUC69
IL:Workflow Only

Time Options

This section contains time-related specifications for the task.

Anchor
Late Start
Late Start
Late Start

Include Page
UC69IL:Late StartUC69
IL:Late Start

Anchor
Late Start Type
Late Start Type
Late Start Type

Include Page
UC69IL:Late Start TypeUC69
IL:Late Start Type

Anchor
Late Start Time
Late Start Time
Late Start Time

Include Page
UC69IL:Late Start TimeUC69
IL:Late Start Time

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

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

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

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

Anchor
Late Start Duration
Late Start Duration
Late Start Duration

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

Anchor
Late Finish
Late Finish
Late Finish

Include Page
UC69IL:Late FinishUC69
IL:Late Finish

Anchor
Late Finish Type
Late Finish Type
Late Finish Type

Include Page
UC69IL:Late Finish TypeUC69
IL:Late Finish Type

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

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

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

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

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

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

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

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

Anchor
Late Finish Time
Late Finish Time
Late Finish Time

Include Page
UC69IL:Late Finish TimeUC69
IL:Late Finish Time

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

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

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

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

Anchor
Late Finish Duration
Late Finish Duration
Late Finish Duration

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

Anchor
Early Finish
Early Finish
Early Finish

Include Page
UC69IL:Early FinishUC69
IL:Early Finish

Anchor
Early Finish Type
Early Finish Type
Early Finish Type

Include Page
UC69IL:Early Finish TypeUC69
IL:Early Finish Type

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

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

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

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

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

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

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

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

Anchor
Early Finish Time
Early Finish Time
Early Finish Time

Include Page
UC69IL:Early Finish TimeUC69
IL:Early Finish Time

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

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

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

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

Anchor
Early Finish Duration
Early Finish Duration
Early Finish Duration

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

Anchor
User Estimated Duration
User Estimated Duration
User Estimated Duration

Include Page
UC69IL:User Estimated DurationUC69
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
UC69IL:CP DurationUC69
IL:CP Duration

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

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

Anchor
CP Duration Unit
CP Duration Unit
CP Duration Unit

Include Page
UC69IL:CP Duration UnitUC69
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
UC69IL:Execution RestrictionUC69
IL:Execution Restriction

Anchor
Restriction Period
Restriction Period
Restriction Period

Include Page
UC69IL:Restriction PeriodUC69
IL:Restriction Period

Anchor
Before Date
Before Date
Before Date

Include Page
UC69IL:Before DateUC69
IL:Before Date

Anchor
Before Time
Before Time
Before Time

Include Page
UC69IL:Before TimeUC69
IL:Before Time

Anchor
After Date
After Date
After Date

Include Page
UC69IL:After DateUC69
IL:After Date

Anchor
After Time
After Time
After Time

Include Page
UC69IL:After TimeUC69
IL:After Time

Anchor
Date List
Date List
Date List

Include Page
UC69IL:Date ListUC69
IL:Date List

Statistics

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

First Execution

Include Page
UC71xIL:First ExecutionUC71x
IL:First Execution

Last Execution

Include Page
UC71xIL:Last ExecutionUC71x
IL:Last Execution

Last Instance Duration

Include Page
UC69IL:Last Instance DurationUC69
IL:Last Instance Duration

Lowest Instance Time

Include Page
UC69IL:Lowest Instance TimeUC69
IL:Lowest Instance Time

Average Instance Time

Include Page
UC69IL:Average Instance TimeUC69
IL:Average Instance Time

Highest Instance Time

Include Page
UC69IL:Highest Instance TimeUC69
IL:Highest Instance Time

Number of Instances

Include Page
UC69IL:Number of InstancesUC69
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
UC69IL:Update buttonUC69
IL:Update button

Launch Task

Include Page
UC69IL:Launch Task buttonUC69
IL:Launch Task button

View Parents

Include Page
UC69IL:View Parents buttonUC69
IL:View Parents button

Copy

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

Delete

Include Page
UC69IL:Delete buttonUC69
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 instance.

Stored Procedure Parameters

See Stored Procedure Task#Adding Adding Stored Procedure Parameters, below.

Variables

Include Page
UC69IL:Variables tabUC69
IL:Variables tab

Actions

Include Page
UC69IL:Actions tabUC69
IL:Actions tab

Virtual Resources

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

Mutually Exclusive

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

Anchor
Instances tab
Instances tab
Instances

Lists all instances of the task.

Triggers

Include Page
UC69IL:Triggers tabUC69
IL:Triggers tab

Notes

Include Page
UC69IL:Notes tabUC69
IL:Notes tab

Anchor
Versions tab
Versions tab
Versions

Include Page
UC69IL:Versions tabUC69
IL:Versions tab

Anchor
Viewing a Stored Procedure Task Instance
Viewing a Stored Procedure Task Instance
Viewing a Stored Procedure Task Instance

...

You can access a task instance from:

...

The following Stored Procedure Task Instance Details contains information on the execution of the task shown in the Stored Procedure Task#Stored Procedure Task Details.
 

Anchor
Stored Procedure Task Instance Details Field Descriptions
Stored Procedure Task Instance Details Field Descriptions
Stored Procedure Task Instance Details Field Descriptions

...

Field Name

Description

General

This section contains general information about the task instance.

Anchor
Instance Name
Instance Name
Instance Name

Name of this task instance.

Instance Number

Include Page
UC69IL:Instance NumberUC69
IL:Instance Number

Description

Include Page
UC71xIL:SummaryUC71x
IL:Summary

Member of Business Services

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

Task

Include Page
UC69IL:TaskUC69
IL:Task

Source Version

Include Page
UC71xIL:Source VersionUC71x
IL:Source Version

Launch Source

Include Page
UC69IL:Launch SourceUC69
IL:Launch Source

Source Instance

Include Page
UC69IL:Source InstanceUC69
IL:Source Instance

Invoked by

Include Page
UC69IL:Invoked byUC69
IL:Invoked by

Anchor
Execution User
Execution User
Execution User

Include Page
UC69IL:Execution UserUC69
IL:Execution User

Calendar

Include Page
UC69IL:Calendar in Task InstanceUC69
IL:Calendar in Task Instance

Time Zone Preference

Include Page
UC69IL:Time Zone PreferenceUC69
IL:Time Zone Preference

Virtual Resource Priority

Include Page
UC69IL:Virtual Resource PriorityUC69
IL:Virtual Resource Priority

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

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

Status

This section contains information about the current status of the task instance.

Status

Include Page
UC69IL:StatusUC69
IL:Status

Exit Code

Include Page
UC69IL:Exit Code-Task InstanceUC69
IL:Exit Code-Task Instance

Status Description

Include Page
UC69IL:Status DescriptionUC69
IL:Status Description

Operational Memo

Include Page
UC69IL:Operational MemoUC69
IL:Operational Memo

Evaluation Time

Include Page
UC69IL:Evaluation TimeUC69
IL:Evaluation Time

Critical

Include Page
UC69IL:CriticalUC69
IL:Critical

Wait Until Time

Include Page
UC69IL:Wait Until Time - StatusUC69
IL:Wait Until Time - Status

Queued Time

Include Page
UC69IL:Queued TimeUC69
IL:Queued Time

Anchor
Trigger Time
Trigger Time
Trigger Time

Include Page
UC69IL:Trigger TimeUC69
IL:Trigger Time

Anchor
Launch Time
Launch Time
Launch Time

Include Page
UC69IL:Launch TimeUC69
IL:Launch Time

Anchor
Start Time
Start Time
Start Time

Include Page
UC69IL:Start TimeUC69
IL:Start Time

End Time

Include Page
UC69IL:End TimeUC69
IL:End Time

Duration

Include Page
UC69IL:DurationUC69
IL:Duration

SQL State

Include Page
UC69IL:SQL StateUC69
IL:SQL State

Rows Retrieved

Include Page
UC69IL:Rows RetrievedUC69
IL:Rows Retrieved

SQL Error Message

Include Page
UC69IL:SQL Error MessageUC69
IL:SQL Error Message

Stored Procedure Details

This section contains assorted detailed information about the task instance.

Anchor
Database Connection
Database Connection
Database Connection

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

Database Connection Variable

Include Page
UC69IL:Database Connection VariableUC69
IL:Database Connection Variable

Anchor
Credentials
Credentials
Credentials

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

Credentials Variable

Include Page
UC69IL:Credentials VariableUC69
IL:Credentials Variable

Maximum Rows

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

Auto Cleanup

Include Page
UC69IL:Auto CleanupUC69
IL:Auto Cleanup

Stored Procedure Name

Include Page
UC69IL:Stored Procedure NameUC69
IL:Stored Procedure Name

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

Anchor
Result Processing
Result Processing
Result Processing

Include Page
UC69IL:Result Processing-Stored ProcedureUC69
IL:Result Processing-Stored Procedure

Anchor
Exit Codes
Exit Codes
Exit Codes

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

Anchor
Parameter Position
Parameter Position
Parameter Position

Include Page
UC69IL:Parameter PositionUC69
IL:Parameter Position

Anchor
Column Name
Column Name
Column Name

Include Page
UC69IL:Column NameUC69
IL:Column Name

Anchor
CN Operator
CN Operator
Operator

Include Page
UC69IL:OperatorUC69
IL:Operator

Anchor
CN Value
CN Value
Value

Include Page
UC69IL:ValueUC69
IL:Value

Retry Options

This section contains specifications for retrying the task.

Anchor
Maximum Retries
Maximum Retries
Maximum Retries

Include Page
UC69IL:Maximum RetriesUC69
IL:Maximum Retries

Retry Indefinitely

Include Page
UC69IL:Retry IndefinitelyUC69
IL:Retry Indefinitely

Retry Interval (Seconds)

Include Page
UC69IL:Retry IntervalUC69
IL:Retry Interval

Current Retry Count

Include Page
UC69IL:Current Retry CountUC69
IL:Current Retry Count

Suppress Intermediate Failures

Include Page
UC69IL:Suppress Intermediate FailuresUC69
IL:Suppress Intermediate Failures

Next Retry Time

Include Page
UC69IL:Next Retry TimeUC69
IL:Next Retry Time

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
UC69IL:Wait To Start - 6.2.1.0UC69
IL:Wait To Start - 6.2.1.0

Anchor
Wait Time
Wait Time
Wait Time

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

Anchor
Wait Day Constraint
Wait Day Constraint
Wait Day Constraint

Include Page
UC69IL:Wait Day ConstraintUC69
IL:Wait Day Constraint

Anchor
Wait Duration
Wait Duration
Wait Duration

Include Page
UC69IL:Wait DurationUC69
IL:Wait Duration

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

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

Anchor
Delay On Start
Delay On Start
Delay On Start

Include Page
UC69IL:Delay On StartUC69
IL:Delay On Start

Anchor
Delay Duration
Delay Duration
Delay Duration

Include Page
UC69IL:Delay DurationUC69
IL:Delay Duration

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

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

Time Options

This section contains time-related specifications for the task instance.

Anchor
Late Start
Late Start
Late Start

Include Page
UC69IL:Late StartUC69
IL:Late Start

Anchor
Started Late
Started Late
Started Late

Include Page
UC69IL:Started LateUC69
IL:Started Late

Anchor
Late Start Type
Late Start Type
Late Start Type

Include Page
UC69IL:Late Start TypeUC69
IL:Late Start Type

Anchor
Late Start Time
Late Start Time
Late Start Time

Include Page
UC69IL:Late Start TimeUC69
IL:Late Start Time

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

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

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

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

Anchor
Late Start Duration
Late Start Duration
Late Start Duration

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

Anchor
Computed Late Start Time
Computed Late Start Time
Computed Late Start Time

Include Page
UC70IL:Computed Late Start TimeUC70
IL:Computed Late Start Time

Anchor
Late Finish
Late Finish
Late Finish

Include Page
UC69IL:Late FinishUC69
IL:Late Finish

Anchor
Finished Late
Finished Late
Finished Late

Include Page
UC69IL:Finished LateUC69
IL:Finished Late

Anchor
Late Finish Type
Late Finish Type
Late Finish Type

Include Page
UC69IL:Late Finish TypeUC69
IL:Late Finish Type

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

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

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

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

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

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

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

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

Anchor
Late Finish Time
Late Finish Time
Late Finish Time

Include Page
UC69IL:Late Finish TimeUC69
IL:Late Finish Time

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

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

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

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

Anchor
Late Finish Duration
Late Finish Duration
Late Finish Duration

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

Anchor
Computed Late Finish Time
Computed Late Finish Time
Computed Late Finish Time

Include Page
UC70IL:Computed Late Finish TimeUC70
IL:Computed Late Finish Time

Anchor
Early Finish
Early Finish
Early Finish

Include Page
UC69IL:Early FinishUC69
IL:Early Finish

Anchor
Finished Early
Finished Early
Finished Early

Include Page
UC69IL:Finished EarlyUC69
IL:Finished Early

Anchor
Early Finish Type
Early Finish Type
Early Finish Type

Include Page
UC69IL:Early Finish TypeUC69
IL:Early Finish Type

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

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

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

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

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

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

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

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

Anchor
Early Finish Time
Early Finish Time
Early Finish Time

Include Page
UC69IL:Early Finish TimeUC69
IL:Early Finish Time

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

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

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

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

Anchor
Early Finish Duration
Early Finish Duration
Early Finish Duration

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

Anchor
Projected Late
Projected Late
Projected Late

Include Page
UC69IL:Projected Late - 6.9.0.0UC69
IL:Projected Late - 6.9.0.0

Critical Path Options

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

Anchor
CP Duration
CP Duration
CP Duration

Include Page
UC69IL:CP DurationUC69
IL:CP Duration

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

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

Anchor
CP Duration Unit
CP Duration Unit
CP Duration Unit

Include Page
UC69IL:CP Duration UnitUC69
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
UC69IL:Execution RestrictionUC69
IL:Execution Restriction

Anchor
Restriction Period
Restriction Period
Restriction Period

Include Page
UC69IL:Restriction PeriodUC69
IL:Restriction Period

Anchor
Before Date
Before Date
Before Date

Include Page
UC69IL:Before DateUC69
IL:Before Date

Anchor
Before Time
Before Time
Before Time

Include Page
UC69IL:Before TimeUC69
IL:Before Time

Anchor
After Date
After Date
After Date

Include Page
UC69IL:After DateUC69
IL:After Date

Anchor
After Time
After Time
After Time

Include Page
UC69IL:After TimeUC69
IL:After Time

Anchor
Date List
Date List
Date List

Include Page
UC69IL:Date ListUC69
IL:Date List

Statistics

This section contains time-related statistics for the task instance.

Anchor
User Estimated End Time
User Estimated End Time
User Estimated End Time

Include Page
UC69IL:User Estimated End TimeUC69
IL:User Estimated End Time

Lowest Estimated End Time

Include Page
UC69IL:Lowest Estimated End TimeUC69
IL:Lowest Estimated End Time

Average Estimated End Time

Include Page
UC69IL:Average Estimated End TimeUC69
IL:Average Estimated End Time

Highest Estimated End Time

Include Page
UC69IL:Highest Estimated End TimeUC69
IL:Highest Estimated End Time

Projected End Time

System-supplied; projected end time of the task instance, calculated by the Controller based on the projected end time of its predecessor (or the maximum projected end time of all its predecessors, if more than one path exists to that task instance) plus its estimated critical path duration.

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.

Status History

History of all statuses that the task instance has gone through.

Buttons

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

Update

Include Page
UC69IL:Update buttonUC69
IL:Update button

Force Finish

Include Page
UC69IL:Force Finish buttonUC69
IL:Force Finish button

Hold

Include Page
UC69IL:Hold buttonUC69
IL:Hold button

Skip

Include Page
UC69IL:Skip buttonUC69
IL:Skip button

Re-run

Include Page
UC69IL:Re-run buttonUC69
IL:Re-run button

View Parent

Include Page
UC69IL:View Parent buttonUC69
IL:View Parent button

Delete

Include Page
UC69IL:Delete buttonUC69
IL:Delete button

Refresh

Refreshes any dynamic data displayed in the Details.

Close

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

Tabs

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

Stored Procedure Parameters

See Adding Stored Procedure Task#Adding Stored Procedure Parameters, below.

SQL Results

Include Page
UC69IL:SQL Result SetUC69
IL:SQL Result Set

SQL Warnings

Include Page
UC69IL:SQL Warning SetUC69
IL:SQL Warning Set

Virtual Resources

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

Exclusive Requests

Include Page
UC69IL:Exclusive Requests tabUC69
IL:Exclusive Requests tab

Notes

Include Page
UC69IL:Notes tabUC69
IL:Notes tab

Anchor
Adding Stored Procedure Parameters
Adding Stored Procedure Parameters
Adding Stored Procedure Parameters

...

Field Name

Description

Parameter Position

Position of this parameter within a list of parameters.

Anchor
Parameter Mode
Parameter Mode
Parameter Mode

Mode of this parameter.
 
Options:

  • Input
  • Output
  • Input/Output

Parameter Type

Type of parameter.
 
Options:

  • NUMERIC
  • DECIMAL
  • INTEGER
  • SMALLINT
  • FLOAT
  • REAL
  • DOUBLE
  • VARCHAR
  • BOOLEAN
  • DATE
  • TIME
  • TIMESTAMP
  • BIGINT
  • VARBINARY

Value is Null

If Stored Procedure Task#Parameter Parameter Mode = Input or Input/Output; Value for the parameter is a database NULL value; applies to the input part of a stored procedure parameter. That is, if a value in a database is undefined, it is NULL, which means it has no set value. An input value can be NULL and is represented by selecting Value is Null.

Input Value

If Stored Procedure Task#Parameter Parameter Mode = Input or Input/Output; Input value of the parameter (up to a maximum of 4000 characters), if any.

Description

Description of this parameter.

Variable Scope

If Stored Procedure Task#Parameter Parameter Mode = Output or Input/Output; applies to parameters associated with a task in a workflow. Scope of the variable to assign the Output value.
 
Options:

  • Self
  • Parent
  • Top Level Parent
  • Global

Variable Name

If Stored Procedure Task#Parameter Parameter Mode = Output or Input/Output; name of variable to assign the Output value.

...

...