We start our indexing at 10:00 PM every evening and we want to allow it run until 4:30 AM, the next day. Therefore, we set the @timelimit variable / parameter to 23400 seconds. The issue is that the system continues to run well past the allotted time, by over 3607 seconds, or until I shut it down.

Thoughts on why it would not stop processing all commands, which is what the code is to promote via the variable?

1 Answer 1


As explained in the documentation (and evident from the procedure source code), TimeLimit is used to

Set the time, in seconds, after which no commands are executed.

(emphasis above is mine).

A command that started before the threshold will keep running until it completes.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.