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 an

swer 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.

References: http://technet.microsof

t.com/en-us/library/hh849759.aspx