You maintain a SQL Server 2008 instance. You create a new SQL Agent job that includes a
Windows PowerShell job step.
The PowerShell job step uses the SQLCmd utility to transfer data between servers.
You need to ensue that an operator named ResponseTeam is notified by an e-mail message
if the job fails.
What should you do?
A.
Enable Notifications. Create the ResponseTeam operator. Direct the Notification to the
ResponseTeam operator on job failure.
B.
Enable Notifications. Create the ResponseTeam operator. Direct the Notification to the
ResponseTeam operator on failure of the Powershell job step.
C.
Create the ResponseTeam operator. Assign the ResponseTeam operator as the failCsafe
operator. Enable the job.
D.
Create the ResponseTeam operator. Configure the job step proxy account to use the
ResponseTeam operator account. Select the proxy account for the e-mail profile.
Explanation: