PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are responsible for maintaining scheduled jobs for the SQL Server 2005 databases in your department. One of the jobs aggregates data from multiple sources for reports. This job runs daily. The job consists of multiple steps. Each step aggregates data for a specific report. A user reports that the data for some of the reports has not been updated recently. You need to ensure that every step of the job that aggregates data executes even when errors occur. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Combine all of the steps into a single step that runs once a day.

B.
Create a notification that alerts you when an error occurs so that you can correct the error and restart the job.

C.
Change the On Failure action to go to the next step.

D.
Configure the job to retry the step.


Leave a Reply