Sql server agent job fail

Jefferson 426 Reputation points
2024-03-28T09:38:38.8666667+00:00

The error message is

An idle CPU condition has not been defined

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
0 comments
Accepted answer
  1. Olaf Helper 40,816 Reputation points
    2024-03-28T09:59:01.45+00:00

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,821 Reputation points
    2024-03-29T01:57:25.89+00:00

    Hi @Jefferson,

    You may need to set CPU Idle Time and Duration.

    Using SQL Server Management Studio

    To set CPU idle time and duration

    In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

    Right-click SQL Server Agent, click Properties, and select the Advanced page.

    1. Under Idle CPU condition, do the following: Check Define idle CPU condition. Specify a percentage for the Average CPU usage falls below (across all CPUs) box. This sets the usage level that the CPU must fall below before it is considered idle. Specify a number of seconds for the And remains below this level for box. This sets the duration that the minimum CPU usage must remain at before it is considered idle.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments