Friday, March 30, 2012

Question about scheduled job

You are the administrator of SQL Server 2000 computer. You create a 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.
The processor utilization option works in conjunction with the
settings for the idle time or number of seconds the cpu remains below
the utilization percent specified. If you fall below the utilization
and the job never fires, it's generally due to the number of seconds
you have specified for the idle time never being hit so you'd want to
try lowering the number of seconds that the processor utilization
needs to be at the specified percentage. Once you hit the specified
number of seconds, the CPU is considered idle.
-Sue
On Wed, 8 Sep 2004 07:33:03 -0700, "Eric"
<Eric@.discussions.microsoft.com> wrote:

>You are the administrator of SQL Server 2000 computer. You create a job that
>performs several maintenance tasks on the servers databases. You want the
>job to run whenever the servers 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 servers 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.

No comments:

Post a Comment