Navigation:  IM Sequencer > Schedule tasks > Steps > Custom step >

SQL query step

Previous pageReturn to chapter overviewNext page


The SQL Query step is a custom step that will execute a specific sql query in a SQL database


       General setting
       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.


Sql query
The query that will be executed when this step is started


Server name
The server name
Database name
The database name where the stored procedure is in


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 the stored procedure).


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


The password that belongs to the username.


Handle errors                
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.


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 query step type settings


Page url: