You are a database administrator for your company. You are managing the production database Prod1 that resides on the SQL Server 2008 instance named Sql1.

You perform the following tasks on Prod1 as a part of your daily activities:

* Perform a differential database backup at 8:00 P.M.
* Rebuild indexes on database tables at 9:00 A.M.
* Perform a backup of the transaction log in the database at 12:00 P.M.
* Update the database statistics at 8:00 A.M.

You want to automate these tasks to occur at the scheduled time on all weekdays.
What should you do? (Choose two. Each correct answer represents part of the solution.)

A.
Ensure that the SQL Server Agent is running.

B.
Ensure that SQL Server Reporting Services is running.

C.
Create one job for all the tasks, and schedule each task to run at the desired time.

D.
Create four different jobs for the tasks, and schedule each job to run at the desired time.

Explanation:
You should ensure that the SQL Server Agent is running, create four different jobs for the tasks, and schedule each job to run at the desired time. When you create a job in SQL Server, you can run the job at a particular time. You cannot schedule the different tasks within a job to be performed at different times. If you want each task to be performed at a different time, you should create one job for each task. The SQL server will then perform these tasks at the scheduled time. Additionally, to enable the SQL server to perform the tasks successfully, the SQL Server Agent should be running. If the SQL Server Agent is not running, the scheduled jobs will not be run. The SQL Server Agent is the service responsible for executing scheduled SQL administrative tasks. After each of the jobs is created, you can change the properties of the job by viewing the Job Schedule Properties dialog box. To disable a job, you can clear the Enabled check box in the Job Schedule Properties dialog box. Disabling a job is a better choice than deleting the job if you think you may need to re-enable the job in the future. The Enabled check box is shown in the following image:

You can also change the schedule type and schedule frequency from this dialog box and configure the duration for the job. The Schedule type option can be configured with one of the following settings:
The Frequency section only becomes available if the Recurring schedule type is selected. You should not ensure that SQL Server Reporting Services is running. SQL Server Reporting Services is not required to perform scheduled tasks on SQL Server. SQL Server Reporting Services is a server-based tool that can be used to create reports that contain data from different sources, such as SQL Server, Analysis Services, or Microsoft .NET data providers. You can create different types of reports using SQL Server Reporting Services, such as tabular, matrix and free-form reports. You should not create one job for all the tasks and schedule each task to run at the desired time. You cannot schedule different tasks within a job to run at different times. All the tasks in a job must be scheduled to run at the same time. If you want to schedule different tasks to be performed at different times, you should create a separate job for each task.

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 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Automating Administrative Tasks (SQL Server Agent) > About SQL Server Agent Copyright 2011 Transcender LLC, a Kaplan Professional Company. All Rights Reserved.

Page 3 of 14 TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Automating Administrative Tasks (SQL Server Agent) > Implementing Jobs > Creating Jobs