Sql server agent job fail

Question

The error message is

An idle CPU condition has not been defined

Answer 1

That's not an error message, only a hint, that the idle condition isn't defined; no issue at all.

See

https://learn.microsoft.com/is-is/sql/ssms/agent/set-cpu-idle-time-and-duration-sql-server-management-studio?view=sql-server-ver15&viewFallbackFrom=azure-sqldw-latest

Answer 2

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.