Which tool should you use?

You are your company’s SQL administrator. You have two SQL Server 2008 computers named SQL1 and SQL2.
Both servers have several jobs that are configured to run on a daily basis. Over recent weeks, the job history log has grown much larger than anticipated.
You need to ensure that job history that is older than 60 days is removed from the job history log. Which tool should you use?

You are your company’s SQL administrator. You have two SQL Server 2008 computers named SQL1 and SQL2.
Both servers have several jobs that are configured to run on a daily basis. Over recent weeks, the job history log has grown much larger than anticipated.
You need to ensure that job history that is older than 60 days is removed from the job history log. Which tool should you use?

A.
SQL Server Configuration Manager

B.
Database Engine Tuning Advisor

C.
SQL Server Profiler

D.
SQL Server Management Studio

Explanation:

You should use SQL Server Management Studio to ensure that job history that is older than 60 days is removedfrom the job history log. To configure this, you can perform the following steps:1. Open SQL Server Management Studio.2. Connect to the SQL Server instance you want to configure, and expand that instance.3. Right-click SQL Server Agent
, and click Properties .4. Select the History page in the SQL Server Agent Properties dialog box.5. Select the Automatically remove agent history option, and configure appropriate time period.You can also use SQL Server Management Studio to clear the SQL Server Agent event logs. You should not use SQL Server Configuration Manager. This tool is used to configure the SQL server, includingmanaging services, configuring network protocols, and managing network connectivity configuration. You should not use Database Engine Tuning Advisor. This tool is used to automatically identify the recommendedindexes, views, and partitions for a particular workload. You should not use SQL Server Profiler. This tool is used to capture events that are occurring on the SQL serverfor later analysis.

Objective:
Maintaining SQL Server Instances

Sub-Objective:
Manage SQL Server Agent jobs.

References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administration: How-to Topics > Automated Administration How-to Topics > How To: Set Up the Job History Log(SQL Server Management Studio)



Leave a Reply 0

Your email address will not be published. Required fields are marked *