I have one SQL Optimization task which runs on database where daily refresh is done (db start at 03:00 and shutdown at 00:00).
Optimizer generate 1300 cases and all cannot be run in one day.
When db shutdown, Optimizer hangs and in many cases it is not possible to resume later (after SQL Optimizer crash).
If I stop after some cases, save the result and reopen again-want to resume, SQL Optimizer resume from the beginning.
Seems that all should be in such a cases done manually. Select portion of cases and run and manually save and continue next time where it stopped previously.
is there a better way to do that?
I would be possible if SQL Optimizer can be started from command line to start task automatically…this will be really a nice new feature.