Exit 70-462 Administering Microsoft SQL Server 2012/2014 Databases
Question 4 of 5
0% complete
Q4 Single choice

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.

Previous Next