Microsoft
70-465 · Question #34
You have a SQL Server 2014 instance named SQL1. SQL1 creates error events in the Windows Application event log. You need to recommend a solution that will run an application when SQL1 logs a specific
The correct answer is D. A job E. A trigger. Use a trigger that starts a job which executes the application.
Submitted by thandi_sa· Mar 5, 2026Design and implement database solutions for SQL Server
Question
You have a SQL Server 2014 instance named SQL1. SQL1 creates error events in the Windows Application event log. You need to recommend a solution that will run an application when SQL1 logs a specific error in the Application log. Which SQL elements should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)
Options
- AA policy
- BA maintenance plan
- CAn alert
- DA job
- EA trigger
How the community answered
(37 responses)- A3% (1)
- B3% (1)
- C11% (4)
- D84% (31)
Explanation
Use a trigger that starts a job which executes the application.
Topics
#SQL Server Agent#alerts#jobs#event log monitoring
Community Discussion
No community discussion yet for this question.