sql server 2012 jobs not working

Question

Hello,

I am using sql server 2012 as a database.
But suddenly jobs are not working in sql server.
I have restarted sql server agent and sql server so many times but no luck.
Below error message comes

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

Please help me.

Answer 1

"Not working" means what exactly? Do you get error message (which one)?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

No error message comes

But I have restarted sql server agent and sql server so many times but no luck.
Below error message comes

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

Answer 3

is it a particular job which is failing?

Answer 4

Hi AparnaS

Go through the bellow link which set the Idle CPU condition 

This link may help you

https://docs.microsoft.com/en-us/sql/ssms/agent/set-cpu-idle-time-and-duration-sql-server-management-studio?redirectedfrom=MSDN&view=sql-server-ver15

Thanks and regards