IMPORTANT: Order of step invocation is crucial, as some steps use values set in previous steps. Omit the keyword “synchronous” to invoke a step or pipeline asynchronously on the Connect server. We use synchronous in the examples to ensure a command completes before returning control back to the command prompt.

 

1. Invoke Step 1.

 

1 SQL> invoke synchronous step s_get_month_period_type;

 

2. Invoke Step 2.

 

1 SQL> invoke synchronous step s_set_period_end_date;

 

3. Invoke Step 3.

 

1 SQL> invoke synchronous step s_set_period_name;

 

4. Invoke Step 4.

 

1 SQL> invoke synchronous step s_create_pay_extract;

 

Again, after each command, locate a status_message of “ok” in the output to confirm your command succeeded.