Show Invocations

Summary

The SHOW INVOCATIONS command displays the summary history of each step or pipeline invoked within Connect. The command also provides status information for actively running invocations.

Syntax

show invocations [for (pipeline | step) <name>];

Parameters

Parameter
Description
<name>
The name of the pipeline or step.

Details

Use to track the processing history of completed and actively running step and pipeline instances. \

SHOW INVOCATION DETAILS provides more granular information for pipeline member objects.

Examples

show invocations;
 
select * from (show invocations) order by created_instant;
show invocations for pipeline p1;
 
select id, state, status, object_name, created_instant, completed_instant from (show invocations for step s_validate_orders_completed) where status = 'pass' and state = 'completed';

Related Commands

ABORT INVOCATION

INVOKE PIPELINE

INVOKE STEP

SHOW INVOCATION DETAILS