Microsoft Exam Questions

Which of the following will show you a history of job errors that have occurred in jobs scheduled to

Which of the following will show you a history of job errors that have occurred in jobs scheduled to run in an SQL Server 2012 installation?

A. Look at the sys.all_job_hist table.

B. In Management Studio, navigate to SQL Server Agent –

> Error Logs and look at the log for the corresponding date.

C. Open the c:\error\job.log file and search for the particular job and the errors you wish to view.

D. You must use T-SQL to write a job-logging procedure to monitor jobs.

QUESTION