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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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