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
Explanation:
Use a trigger that starts a job which executes the application.