Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Implementing security for SQL Server Agent jobs management


The integrity of the data is only as good as your ability to secure the data platform. Typically, security doesn't stop in authentication and authorization to access the SQL Server. The additional process of encrypting data and providing a secured backup system is essential. Similarly, scheduling such data management activities is carried over using SQL Server Agent service. An SQL Agent job is a complex database object with many details involved in the definition. There are even more details to consider while a job is actually running, but it's not convenient to examine the details for SQL Agent jobs using SSMS and the filtering is less than ideal.

In this recipe, we will be implementing security for SQL Server Agent Jobs management by using the credentials and proxy methods. A credential is a record that contains the authentication information required to connect to a resource outside of SQL Server. A proxy is really just the mapping...