Microsoft · DP-300
SQL Server Agent jobs
DP-300 · Lesson 16 of 22 · 2:24:20
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: SQL Server Agent jobs and steps, shared schedules, operators, Database Mail notifications, and alerts on errors, severities, and performance conditions, what differs on Managed Instance, and troubleshooting jobs with their history, owners, and permissions. Includes three original practice questions.
Preview the topics
- Contoso’s index maintenance must run every night at 1:00 on weekdays, and also every two hours on the last day of each month. What’s the simplest setup?
- On Contoso’s Managed Instance, the DBA configures Database Mail with a profile named ContosoMail, but the Agent never sends job failure emails. What’s wrong?
- A Contoso Agent job has failed every night since a DBA left the company, with no other change. What’s the most likely cause?