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 ;
Step 2: Create DB Schema and DB Source
Step 3: Design the process flow. Follow the steps shown below
Comments
0 comments
Article is closed for comments.