Monitoring SQL Server 2014 with Notifications and Alerts

Sep 26, 2016 - Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif... https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book.
3MB taille 50 téléchargements 257 vues
Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

1 of 10

Lab Answer with Notifications

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Server 2014

Lab: Using Exercise

Task 1: Prepare

1.

Ensure running,

are both ADVENTUREWORKS\Student

with the 2.

In the D:

then click

Run as 3.

Click Yes

file, and wait

for the

Task 2: Configure

1.

Start SQL

database engine

instance 2.

In Object

right-click

Database 3.

In the Welcome

.

4.

In the Select

Mail and

click Next 5.

In the New and click

Agent Profile, Profile' dialog

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

2 of 10

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

box, click 6.

In the New

and click

OK:

o

Account

o

E-mail

o

Display

o

Reply

o

Server

7.

In the New

8.

In the Manage

Agent Profile

profile, 9.

In the Configure

Complete the

Wizard

Task 3: Test

1.

In Object

2.

In the Send

Server

Agent student@adventureworks. 3.

View the

email

message 4.

Double-click

message, close

it and delete 5.

In the Database

Server

Management

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

3 of 10

6.

In SQL

7.

Enter the

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

SELECT SELECT

8.

View the

and the second

shows records

Result: After named SQL

new profile

Exercise

Task 1: Create

1.

In Object

click

NewOperator 2.

In the New

E-mail name

box type 3.

In Object

click

NewOperator 4.

In the New

E-mail

name box

Task 2: Configure

1.

In SQL

Server Agent

and click

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

4 of 10

2.

In the SQL Enable

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

page, select Server Agent

Profile 3.

In the SQL

operator, in

the Operator

setting, select

E-mail 4.

In Object

prompted to

confirm,

Task 3: Configure

1.

In Object

existing jobs.

2.

Right-click

3.

In the Job

box, on the

Notifications

fails. Then

Properties.

click OK 4.

Right-click

5.

In the Job Notifications

Properties. box, on the fails. Then

click OK 6.

Right-click

7.

In the Job Notifications

Properties. the completes.

Then click 8.

Right-click

9.

In the Job

Notifications

tab, select

Then click OK.

10. Expand Notifications

the defined for this 26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

5 of 10

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

operator.

Task 4: Test

1.

In Object click Start

AWDataWarehouse job and failed and click

Close. 2.

In Object Start Job

job and click and click

Close. 3.

In Object Start Job

and click and click

Close. 4.

5.

Under the

the History

page, note

.

In the C:

have been

created. 6.

Open each

for the

Back Up

notification for the

Back Up

Back Up

Database

minimize the

Drop window.

Result: After Team, configured Database Mail Up Database InternetSales

DBA Profile AWDataWarehouse, Back Up Log -

Exercise

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

6 of 10

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Task 1: Create

1.

In SQL

Agent,

right-click 2.

In the New Full Alert

InternetSalesLog then select

Error number 3.

In the New Back Up

select the Notify

operators 4.

In the New

error text in,

select E-mail

Task 2: Test

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

7 of 10

1.

In SQL

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

D:\Labfiles

\Lab13\Starter 2.

Click Execute

InternetSales

database 3.

In Object and click

Full Alert and Date of

last response 4.

In the C:

messages have

been created. 5.

Double-click notification

should include a Back Up Log -

InternetSales 6.

When you

7.

Close SQL

Result: After Alert.

InternetSales Log Full

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

8 of 10

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

9 of 10

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:06

Lab Answer Key: Module 13: Monitoring SQL Server 2014 with Notif...

10 of 10

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:06