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 automated database tasks

Troubleshoot automated database tasks

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 automated database tasks

“

- Welcome back. This is lesson 12.4, troubleshoot automated database tasks. Lessons 12.1 and 12.2 showed you how to implement maintenance tasks using Azure Elastic Jobs and Azure Automation. These are both great solutions for automating maintenance tasks in Azure. But if something goes wrong, how do you troubleshoot and where do you go look? Let's start with Azure Elastic Jobs. So in lesson 12.1, I mentioned that Elastic Jobs requires a separate database. In fact, I'll quote it. "Elastic Jobs requires a database to be used as a job database, which contains information and metadata about the created and defined jobs, as well as runtime and troubleshooting information." The jobs database includes a table called jobs.job_execution, which include a last message column. If the elastic job fails for whatever reason, the information in this column will tell you why. Now you can get the same information via a PowerShell command, which essentially gets you the same information from the table…

Contents