You have an 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.
http://technet.microsoft.com/en-us/library/hh849759.aspx