EXERCISE 9ENABLING DATABASE MAILYOU HAVE JUST INSTALLED SQL SERVER 2...

4. Locate the DatabaseMail feature and change False to True

and then click on the OK button. Your screen will look like

Figure 4.12.

Figure 4.12

Enabling the DatabaseMail Feature

Security and SQL Agent

SQL Server job steps often need to do more than just execute Transact-SQL.

In order to perform tasks such as operating system commands (CmdExec), executing

Integration Services packages, and PowerShell scripts, various credentials often

associated with Windows logins are necessary. SQL Server Agent Proxies mapped to

the appropriate credentials necessary can be created and associated with one or

more SQL Server Agent subsystems. You can associate one or more proxies with the

available SQL Server Agent subsystems. See Figure 4.13 for the SQL Server Agent

subsystems that you can associate to proxies.

Figure 4.13

SQL Agent Proxies

e

xam

W

arning

Make sure that you understand how the SQL Server Agent uses Proxies

and how the credentials used need to have sufficient permissions to

perform the required task but not in excess of what is needed.