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.)
A. A policy
B. A maintenance plan
C. An alert
D. A job
E. A trigger
The correct answer is C & D not D E.
https://docs.microsoft.com/en-us/sql/relational-databases/performance/set-up-a-sql-server-database-alert-windows?redirectedfrom=MSDN&view=sql-server-2017