Test Pipelines

Use RUN_PIPELINE_ONCE to run a pipeline once on-demand without creating a scheduled job.

RUN_PIPELINE_ONCE is useful for testing a pipeline before you start the pipeline. After you run a pipeline once to test the pipeline and check that it is working as expected, use RESET_PIPELINE to reset the pipeline's state (to the state before you ran RUN_PIPELINE_ONCE).

1. Create a pipeline.

   See Create and Configure Pipelines for more information.

2. Run a pipeline once to test the pipeline.

   BEGIN
       DBMS_CLOUD_PIPELINE.RUN_PIPELINE_ONCE(
           pipeline_name => 'MY_PIPE1'
   );
   END;
   /

   See RUN_PIPELINE_ONCE Procedure for more information.

3. Perform any required checks to verify the pipeline is operating as expected.

   See Monitor and Troubleshoot Pipelines for more information.

4. Reset the pipeline.

   BEGIN  
      DBMS_CLOUD_PIPELINE.RESET_PIPELINE(
        pipeline_name => 'MY_PIPE1',
        purge_data => TRUE
   );
   END;
   /

   See RESET_PIPELINE Procedure for more information.