The SQL step is a custom step that will execute a stored procedure in a SQL database
All general custom step settings are described below, to develop your own step plugin read more here.
The SQL step is called "Traxion.IM.Scheduler.Plugins.Sql.SQLStep"
The following parameters apply for the SQL step.
|The name of the stored procedure to execute|
|•||Stored procedure parameters|
|Optional parameters for the stored procedure, for example @PARAM = N'value1', @PARAM2 = N'value2'".|
|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.|
|If set to true the output will be validated, the output should return 0 (in the 1st record) to validate correctly (or alternate success codes needs to be set on the step).|
|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!)|
Page url: http://www.traxionsolutions.com/imsequencer/help/index.html?sqlsteptype.htm