start whenever cpu becomes idle

Last Post 08 Feb 2012 06:05 AM by rm. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ctseah
New Member
New Member

--
26 Jan 2012 01:15 AM

Hi,

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.

Regards

rm
New Member
New Member

--
26 Jan 2012 06:50 AM
I'll look at server load for couple of days and find out which period has least load then schedule job to run in that period.
ctseah
New Member
New Member

--
07 Feb 2012 07:15 PM

Hi,

Is there anything else I need to configure besides just selecting "whenever cpu becomes idle" in order for this to work ?

For eg. to define cpu idle is x% free, etc.

Thanks

rm
New Member
New Member

--
08 Feb 2012 06:05 AM
Not as I know of.
You are not authorized to post a reply.

Acceptable Use Policy