The SQL trigger is a custom trigger, and specifically build for SQL. This trigger executes a sql query to search for changes.
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
The server name
The database name where the query will be executed on
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|