So, it seems that it is not possible to set a timeout for each individual step in a SQL Server task ( articles from StackExchange ).
MSDN indicates that you can, of course, set the agent timeout:
Questions
- How does agent timeout work?
- Is there any other way (preferably by configuration) for setting a one-step timeout?
- Is there any other way (preferably by configuration) for setting the entire timeout?
source
share