Post reply

An idle CPU condition has not been defined

  • 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

  • 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

  • November 15, 2006 at 3:01 am

    #671883

    Thanks for this documentation,

    Its works now.

     

    Kindest Regards,

    degrem_m
    Degremont

  • June 26, 2007 at 10:53 am

    #715304

    Yes, thanks for the docs Cath.  Keith

  • 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?

  • 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

  • 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?

  • March 16, 2016 at 2:22 pm

    #1865732

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply