You are the administrator of a SQL Server database and wish to schedule database cleaning to occur whenever the server’s utilization drops below a certain threshold. What tool can assist you with this task?

208.

You are the administrator of a SQL Server database and wish to schedule database cleaning to occur whenever the server’s utilization drops below a certain threshold.
What tool can assist you with this task?

Query Analyzer

SQL Server Agent

Enterprise Manager

Service Manager

Data Transformation Services

View Description

SQL Server Agent allows you to configure jobs for execution when utilization drops below a certain threshold