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.


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



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).


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


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: