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.