The SQL Query step is a custom step that will execute a specific sql query in a SQL database
All general custom step settings are described below, to develop your own step plugin read more here.
The SQL query step is called "Traxion.IM.Scheduler.Plugins.Sql.SQLQueryStep"
The following parameters apply for the SQL Query step.
|The query that will be executed when this step is started|
|The database name where the stored procedure is in|
|The instance name, leave default if there is no other instance |
|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 the stored procedure).|
|If integrated security is not used, this account and password are used to connect.|
|The password that belongs to the username.|
|If set to "True" errors with a lower severity (lower than 17) will not halt the execution, but will be logged and the execution will continue.|
|This is the command timeout in seconds, default 30 seconds, set 0 for infinite (not recommended!)|
|This is the connection timeout in seconds, default is 15 seconds, set 0 for infinite (not recommended!)|
| SQL query step type settings|
Page url: http://www.traxionsolutions.com/imsequencer/help/index.html?sqlquerysteptype.htm