TRIGGER

Starts (or queue for execution) one or more pipelines after this one completes. This operation allows you to daisy-chain pipelines and multicast change logs to additional targets.

The Trigger operation can only be specified as the last command in a SQL CDC batch command.

Some DataZen agents limit the number of triggers available based on the SKU.

Starts another pipeline upon completion of the current one. This operation can only be used as the end of a SQL CDC script.

TRIGGER '...' 
    ON < SUCCESS | SUCCESS_WITH_DATA | COMPLETION | ERROR > 
    { DELAY N }
;

ON	The condition to trigger the next pipeline: SUCCESS, SUCCESS_WITH_DATA, COMPLETION, ERROR
DELAY	The number of seconds to wait at a minimum before starting the trigger (0 = no delay)

Example 1

-- Get data from an RSS Feed
SELECT * FROM HTTP [Rss Feed] (GET /econi.xml) APPLY TX (//item);

-- Start one or more pipelines depending on the outcome of this pipeline
TRIGGER 'pipeline_notify' ON SUCCESS;
TRIGGER 'pipeline_sendemail' ON FAILURE;
TRIGGER 'pushToDrive' ON COMPLETION DELAY 30;