Use SHOW INVOCATIONS to review details for the executed pipeline.

1 SQL> select id, state, status, object_type, object_name, created_instant, completed_instant from (show invocations) where object_name = ‘p_pay_extract’;

Now, you can query SHOW INVOCATION DETAILS using the id from the previous query.

1 SQL> select invocation_id, state, status, position, object_type, object_name, parent_name, completed_instant from (show invocation details) where invocation_id = ‘ff8080815127d14e01515ab86f390aa2’;