Navigation:  IM Sequencer > Schedule tasks > Triggers > Custom trigger  >

SQL trigger

Previous pageReturn to chapter overviewNext page

 

The SQL trigger is a custom trigger, and specifically build for SQL. This trigger executes a sql query to search for changes.

 

       General setting
       All general custom trigger settings are described below, to develop your own trigger plugin read more here.

 

Type
 
The SQL trigger is called "Traxion.IM.Scheduler.Plugins.Sql.SQLTrigger"

 

Parameters

 
The following parameters apply for the SQL trigger.

 

Sql query that will be executed

       Type the sql query that will be executed, if 1 or more rows are returned then the trigger will trigger

 

Server name

       The server name

 

Database name

       The database name where the query will be executed on

 

Instance name

       The instance name, leave default if there is no other instance        

 

Use integrated security        
If set to true the service account from the IM Sequencer service will be used to connect (this accounts needs to have sql login right to the appropriate database and rights to execute query).

 

Username        
If integrated security is not used, this account and password are used to connect.

 

Password        
The password that belongs to the username.

 

SQL command timeout

       This is the command timeout in seconds, default 30 seconds, set 0 for infinite (not recommended!)

 

SQL connection timeout

       This is the connection timeout in seconds, default is 15 seconds, set 0 for infinite (not recommended!)

 

 
                               SQL trigger type settings

 


Page url: http://www.traxionsolutions.com/imsequencer/help/index.html?sqltypetriggertype.htm