From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Troubleshoot SQL Server Agent jobs

Troubleshoot SQL Server Agent jobs

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Troubleshoot SQL Server Agent jobs

“

- Welcome back, this is Lesson 10.3: Troubleshoot SQL Server Agent Jobs. So a SQL Server Agent job has failed, you've been notified, and you want to know why the job failed. It's time to put on your sleuthing hat and figure out why. Where do you go look? There are four main areas. For T-SQL job steps, you can configure the job step to output the results of the job step to a file. The information will contain detailed error information if the job fails. The Log to Table option allows you to log the output to the msdb.dbo.sysjobstepslog table. Say that fast 10 times. Here you can query the table directly to view the detailed job step information, including why the job failed or why the step failed. All job execution history is logged to the job tables in the MSDB database. You can view the history of job executions by right clicking a job and selecting View History from the Context menu If a job has failed, reviewing the job details section will provide information as to why the job…

Contents