Using Database Trigger

How to use Database Trigger to automate process flow execution?
-----------------

See the screenshots of the steps described below.
Step 1: Create Database Event object.

Here's a sample SQL Trigger syntax:

create trigger DBEvent on pollingtable for
Insert, Update
as
declare @tpid varchar(50)
declare @queueid varchar(50)
declare @orderid varchar(50)
begin
set @tpid = (select tpid from inserted);
set @queueid = (select queueid from inserted);
set @orderid = (select orderid from inserted);

INSERT INTO dbeventtriggertable VALUES ('Query = WHERE tpid ='''+@tpid +''' and queueid = '''+@queueid +''' and orderid = '''+@orderid +''' ' );

END ;

adp27_3739.jpg

Step 2: Create DB Schema and DB Source

adp28_6272.jpg

adp29_4593.jpg

Step 3: Design the process flow. Follow the steps shown below

adp30_6710.jpg

 

adp31_296.jpg

adp32_2380.jpg

 

adp33_2529.jpg

 

adp34_4068.jpg

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.