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

**URL:** <https://www.finalbuilder.com/forums/t/sql-query-command-not-connection-timeout-in-automise-3/4446>\
**Category:** Discussion\
**Created:** [July 27, 2010, 9:18am UTC](https://www.finalbuilder.com/forums/t/sql-query-command-not-connection-timeout-in-automise-3/4446 "2010-07-27T09:18:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![appserv](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/54ee81/32.png) [@appserv](https://www.finalbuilder.com/forums/u/appserv)\
**Post date:** [July 27, 2010, 9:18am UTC](https://www.finalbuilder.com/forums/t/sql-query-command-not-connection-timeout-in-automise-3/4446/1 "2010-07-27T09:18:04Z")

</div>

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

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.&nbsp; 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&nbsp;makes no difference.&nbsp; I've tested with a very short-running query to prove that.

Thanks, any help appreciated!

&nbsp;

---

<div class="post-metadata">

**Author:** ![paulsamways](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/p/e8c25b/32.png) [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)\
**Post date:** [July 28, 2010, 12:23pm UTC](https://www.finalbuilder.com/forums/t/sql-query-command-not-connection-timeout-in-automise-3/4446/2 "2010-07-28T12:23:54Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![appserv](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/54ee81/32.png) [@appserv](https://www.finalbuilder.com/forums/u/appserv)\
**Post date:** [May 1, 2013, 1:03am UTC](https://www.finalbuilder.com/forums/t/sql-query-command-not-connection-timeout-in-automise-3/4446/3 "2013-05-01T01:03:04Z")

</div>

Great, thank you.