You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server 2008 instance.
TestKing.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 TestKing 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 TestKingEmployees operator.
E.
By Adding a stored procedure to develop the TestKingEmployees operator.
F.
By Creating Transactions Log and develop the TestKingEmployees operator.
G.
By directing the Notification to the TestKingEmployees operator on job failure.
H.
By directing the Notification to the TestKingEmployees operator on job success.