An idle CPU condition has not been defined

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  November 14, 2006 at 7:12 am

  #115080

  Hi,

  I created a task in my SQL Agent, but when I started my job, I have this message 

  [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

  In sql 2005 where I must define CPU Condition ?

  Thanks.

   

  ---

  Kindest Regards,

  degrem_m
  Degremont

• Cath Trimble

  SSCarpal Tunnel

  Points: 4231

  More actions

  November 15, 2006 at 2:30 am

  #671879

  Hi degrem,

  This link helped me, hope it does you too:  http://msdn2.microsoft.com/en-us/library/ms189065.aspx

  Cath

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  November 15, 2006 at 3:01 am

  #671883

  Thanks for this documentation,

  Its works now.

   

  ---

  Kindest Regards,

  degrem_m
  Degremont

• Keith_Evans

  SSC Enthusiast

  Points: 150

  More actions

  June 26, 2007 at 10:53 am

  #715304

  Yes, thanks for the docs Cath.  Keith

• miltonmharper

  Mr or Mrs. 500

  Points: 545

  More actions

  March 6, 2008 at 6:25 am

  #785893

  Hello. Ours currently isn't set. We have the same set up of SQL 2005 Clustered between two servers. Could I ask what you set yours to?

• TcW_1978

  SSCrazy

  Points: 2018

  More actions

  May 25, 2009 at 7:01 am

  #999650

  What values did you use? I got the same problem and can't seem to find what should go in those two fields.

  Average CPU usage falls below : ( x ) %

  And remains below this level for : ( y ) seconds

  Is there a way to calculate and/or know what I have to put in those two fields?

  Thanks,

  tcw

• KoldCoffee

  SSCoach

  Points: 18971

  More actions

  July 17, 2010 at 10:16 am

  #1194541

  Is it possible that SQL Server Agent wouldn't execute a job if CPU idle went below a certain threshold?

• frelka

  SSC Enthusiast

  Points: 101

  More actions

  March 16, 2016 at 2:22 pm

  #1865732

  I just went with the default. 10% and 600 seconds.