By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,660 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,660 IT Pros & Developers. It's quick & easy.

SQL Server Agent Alert System - Operators?

P: n/a
aj
SQL Server 2005 SP2 64-bit

I am quite confused about the SQL Server Agent Alert System.

I have configured Database Mail, establishing my Profile(s) and
Account(s), and specifying SMTP server+port. I then configured SQL
Server Agent, under Properties->Alert System, to use Database Mail,
specifying a particular Mail Profile to use.

I then go into the properties of one of my Agent Jobs, and under
Notifications, expect to see, perhaps by default, the Database Mail
profile I picked when configuring Agent, or perhaps an account under
that particular profile.
Instead I have to pick an Operator. What do Operators have to do w/
the accounts/profiles in Database Mail? Shouldn't Database Mail have
made Operators unnecessary and obsolete?

When I define an Operator, I only specify an e-mail address, not an SMTP
server or port. How does it know the server/port to use? Does it
use those defined under Database Mail? If so, what account?

Can someone explain this to me?

thanks

aj
Sep 18 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.