I have a job which tends to fail when the server is busy.
I would like to try out the schedule to run with "whenever cpu becomes idle".
However it does not seem to be running.
I have restarted the sql agent to isolate that possibility that sql agent needs to be restarted.
But still it did not run despite restarting the sql agent and waiting for a while, there was also brief moment that CPU was actually 0 utilization from task manager.
How does this work actually ?
It only need to run once a day.
Thanks in advance.