CODEWITHSUNDEEP
sql-servertimeoutscheduled-tasks
Alberto De Caro
Alberto De Caro

Reputation: 5213

SQL Server job timeout

So, it seems that it is not possible to set the timeout for each single step in a SQL Server job (article from StackExchange).

MSDN points out that you can of course set the Agent timeout:

Questions

  1. How does Agent time-out work?
  2. Is there any other way (preferably by configuration) to setup the single step timeout?
  3. Is there any other way (preferably by configuration) to setup the whole job timeout?

Upvotes: 5

Views: 4261

Answers (1)

Dave Hilditch
Dave Hilditch

Reputation: 5439

To answer question 2, I'm not sure if this is the best option but you could use OPENROWSET to control a single step timeout.

http://msdn.microsoft.com/en-us/library/ms190312.aspx

Just because OPENROWSET is normally used to access remote servers doesn't mean it has to be.

Probably this is similar to how agent timeout works.

You could even use this to control the whole job timeout although if you want to do it by configuration you'd have to create your own tables.

I'm not sure this is the best solution but it's a solution at least.

Upvotes: 3

Related Questions