Page 104 - DCAP508_DATABASE_ADMINISTRATION

Database Administration Deepak Mehta, Lovely Professional University

Notes Unit 7: Automating Administrating Tasks

CONTENTS
Objectives
Introduction

7.1 Meaning of Database Mail
7.1.1 Reliability Factors of Database Mail
7.1.2 Scalability Factors of Database Mail
7.1.3 Security Features of Database Mail

7.1.4 Supportability Features of Database Mail
7.1.5 Database Mail Configuration Wizard
7.1.6 Database Mail Architecture
7.2 Event Notifications

7.2.1 Understanding Event Notifications
7.2.2 Designing Event Notifications
7.2.3 Defining Notification Scope
7.2.4 Creating the Event Notification

7.3 SQL Server Agent
7.3.1 Meaning of SQL Server Agent
7.3.2 Configuring SQL Server Agent
7.3.3 Setting Required Permissions

7.4 Maintenance Plans
7.4.1 Features
7.4.2 How to Create a Maintenance Plan?
7.4.3 Maintenance Plan Wizard

7.5 Summary
7.6 Keywords
7.7 Review Questions
7.8 Further Readings

Objectives

After studying this unit, you will be able to:

Know about various types of automating administrative tasks in SQL server
Comprehend the meaning and features of database mail
Understand the concept of SQL server agent
Familiarize with maintenance plans in SQL server

98 LOVELY PROFESSIONAL UNIVERSITY