Execute Query Timeout
Any database query executed using the Execute SQL Query Action has a default timeout of 30 seconds.This timeout can be modified by adding the following to the client configuration file:
<appSettings>
<add key\="inrule:runtime:dbCommand:dbCommandTimeout" value\="50">
</appSettings>
OR
<configuration>
<configSections>
<section name\="inrule.runtime" type\="InRule.Runtime.Configuration.RuntimeConfigSectionHandler, InRule.Runtime" /> ...
</configSections>
...
<inrule.runtime>
<dbCommand commandTimeout\="50" /> ...
</inrule.runtime>
This commandTimeout maps to the standard .Net IDbCommand.CommandTimeout property and its value is specified in seconds. In the above example, a wait time of 50 seconds is set, before terminating to execute a command and generate an error.