Setting Up Your SQL Server Agent Correctly
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Fri, 13 Jun 2014 06:00:00 UT
Indexed on
2014/06/13
9:36 UTC
Read the original article
Hit count: 119
Filed under:
It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.
<--- DBA Team 3 (DBA Bundle) -->Can 41,000 DBAs really be wrong? Join 41,000 other DBAs who are following the new series from the DBA Team: the 5 Worst Days in a DBA’s Life. Part 3, As Corrupt As It Gets, is out now – read it here. |
© SQL Server Central or respective owner