Create job that performs several maintenance tasks on the server s databases. You want the job to run whenever the server s processor utilization falls below 5 percent.You create a new schedule for the job and specify the Start whenever the CPU(s) become idle option. After several days, you notice that the job has never executed although the server s processor utilization has fallen below 5 percent several times. What should you do?
A. Modify SQL Server Agent properties and specify a smaller idle time.
B. Modify SQL Server Agent properties and specify a larger idle time.
C. Write a stored procedure that executes the job whenever the @@IDLE system variable is less than 5.
D. Write a stored procedure that executes the job whenever the @@IDLE system variable is greater than 1.
Answer:A
Create job that performs several maintenance tasks on the server s databases. You want the job to run whenever the server s processor utilization falls below 5 percent.You create a new schedule for the job and specify the Start whenever the CPU(s) become idle option. After several days, you notice that the job has never executed although the server s processor utilization has fallen below 5 percent several times. What should you do?
A. Modify SQL Server Agent properties and specify a smaller idle time. B. Modify SQL Server Agent properties and specify a larger idle time. C. Write a stored procedure that executes the job whenever the @@IDLE system variable is less than 5. D. Write a stored procedure that executes the job whenever the @@IDLE system variable is greater than 1.