0

I would like to limit the duration of the index maintenance procedure of Ola Hallengren to be 7200 seconds (2 Hours)

I found parameter TimeLimit defined as: Set the time, in seconds, after which no commands are executed. By default, the time is not limited.

Does this mean if a command is already running and the time limit reach it will force it to stop or will continue and will not run any command after ?

Thanks

1 Answer 1

1

If a command is already running and the time limit reach it: will continue and will not run any command after. To answer your question I saw stored procedure definition. Find keyword @TimeLimit

1
  • That means, if the time limit is set to 5 hours (18000 seconds) and if a new command is started at 4 hr 59 minutes, then once the time limit reach it to 5 hrs it will still continue that current command but no further commands will be performed after that, correct? Dec 22, 2020 at 21:17

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.