SQL query command (not connection) timeout in Automise 3?

Automise Discussion
1

Hi there, how can I set a command timeout in the ADO dataset iterator? 

I have various SQL queries that will take more than 30 seconds to complete, and the Automise ADO dataset iterator seems to be timing out at that point.  The queries are simple selects, they return a lot of rows and cannot be optimised further.

This is not a connection timeout issue, setting that to 120 seconds makes no difference.  I've tested with a very short-running query to prove that.

Thanks, any help appreciated!

 

2

Hi Nathan,

You can set the ‘TimeOut’ property on the action using the action inspector (View -> Action Properties Tab), the property will listed under the ‘Other’ category. This will set the command timeout.

Regards,
Paul.

3

Great, thank you.