Setting Up Your SQL Server Agent Correctly This is an off-site link.  Please review our Terms of Service for additional information.

(Saurabh Dhoble) 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.

Read this article...

comments powered by Disqus