Solved

SQL Server 2005 Job Agent - Setting up Notifications and Alerts

Posted on 2010-09-15
4
283 Views
Last Modified: 2013-04-03
How do I set up Notifications and Alerts for SQL Server job agents? I am trying to find where I should enter email address but can't find it. There's a drop down menu that seems like will show my options of which email address I want to select  but how do I enter and where do I enter the email/phone number for notifications or alerts or both.

I am running SQL Server 2005.

Thanks much.
0
Comment
Question by:awarraic
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
avirups earned 500 total points
ID: 33684194
Setup your email by configuring a new "Operator". Then choose the operator from the drop down list.
0
 
LVL 8

Expert Comment

by:avirups
ID: 33684211
You can find Operator under SQL Server Agent in your Management Studio.
0
 

Author Closing Comment

by:awarraic
ID: 33684252
Thank you so much for the prompt reply. All set.
0
 

Expert Comment

by:Emi975
ID: 39045428
Thanks for the help. I thought by configuring something under Database Mail that it would show as a user.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Row-Level Security 2 20
T-SQL Using IN with a subquery 3 12
Mssql SQL query 14 28
DATETIMEOFFSET feature 1 0
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now