SQL warehousing — listFailedControlFlowInstances command

Displays the warehouse control flow instances that failed.

Syntax


>>-listFailedControlFlowInstances------------------------------->

>--+-+-----------------------+--+-------------------------+--+---------------------------+-+-><
   | '-| filter-definition |-'  '- -format--output-format-'  '- -connectionName--conName-' |   
   +- -help--------------------------------------------------------------------------------+   
   +-| -timeQueryType |--------------------------------------------------------------------+   
   '-| -timeQueryScope |-------------------------------------------------------------------'


filter-definition

|--+- -app--application-name---------+--------------------------|
   '- -controlFlow--controlFlow-name-'

Parameters

-app application-name: Restricts output to instances of control flows that are associated with the application-name application.
-controlFlow controlFlow-name: Restricts output to instances of the controlFlow-name control flow.
-format output-format: Formats output by using the specified formatting option. Only the comma separated values (csv) format is supported.
-timeQueryType -timeQueryType: Query on type : StartTime or FinishTime.
-timeQueryScope -timeQueryScope: Time scope for query : (yyyy/mm/dd-hh:mm:ss,yyyy/mm/dd-hh:mm:ss). You can also use “any” for the time.
-connectionName conName: Specifies the server connection to issue the command to.
-help: Displays help for this command.

Description

Each list entry contains the application name, control flow name, instance name, start time, and finish time.

Use the getFailedControlFlowInstance command to retrieve more information about the failure.