QuestionQ65

VerifiedConfigure and manage automation of tasks

You have SQL Server on an Azure virtual machine named SQL1.

SQL1 has an Agent job that backs up all databases. You add a user named dbadmin1 as a SQL Server Agent operator.

You need to make sure that dbadmin1 receives an email alert if a job fails.

Which three actions should you perform, in sequence?

Drag & Drop
Explanation

SQL Server Agent job notifications use Database Mail. Enable and configure Database Mail first, then configure SQL Server Agent to use its mail profile. Finally, configure the backup job’s notification to email the SQL Server Agent operator when the job fails.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!