You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com has a SQL Agent job that contains a Windows PowerShell job step that uses
the SQLCmd function to move data between servers. The SQL Agent job is working fine for a
couple of week. However, occasionally the job fails.
Your CEO tells you that all employees in ABC must be notified by e-mail if this job is not
successfully run.
What steps should you take? (Each correct option is part of the answer. Choose THREE.)
A.
By Enabling the Notifications.
B.
By setting the operator as the failsafe operator.
C.
By enabling all jobs.
D.
By creating the ABCEmployees operator.
E.
By Adding a stored procedure to develop the ABCEmployees operator.
F.
By Creating Transactions Log and develop the ABCEmployees operator.
G.
By directing the Notification to the ABCEmployees operator on job failure.
H.
by directing the Notification to the ABCEmployees operator on job success.
Explanation: