Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Maxer
Yak Posting Veteran
51 Posts |
 Posted - 2007-06-27 : 12:22:04
|
| I want to enable notifications for SQL Agent for my backup jobs.I configured database mail and that works, it sent me a test message. However, when I go to tell the SQL Agent to use it, it sees database mail as an option, but the drop down for Profile is blank.Any thoughts on what I may be doing wrong?(I restarted the agent service just in case) |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-27 : 12:24:13
|
| Did you make the profile public?Did you setup a default profile?CODO ERGO SUM |
 |
|
|
Maxer
Yak Posting Veteran
51 Posts |
Posted - 2007-06-27 : 12:26:58
|
| Yes.In SQL Server Agent Properties I select Alert System.Then I check "enable mail profile" and mail system is Database Mail, Mail Profile is (well my mail profile)I then click OK. (however the button to TEST is grayed out).I select one of the jobs under SQL Server Agent, then properties of the job:Notifications: I check the E-Mail box: then the drop down is blank.EDIT: I did double check on the profile. It is set to PUBLIC and Default Profile is set as YES. |
|
|
|
LA768
Starting Member
9 Posts |
Posted - 2007-07-04 : 10:50:48
|
| Did you add on "Operator"?Larry :-) |
|
|
|
Maxer
Yak Posting Veteran
51 Posts |
Posted - 2007-07-05 : 10:20:22
|
| An operator?Hmm, let me look...I don't know, I'll need to lookup what that is apparently. |
|
|
|
Maxer
Yak Posting Veteran
51 Posts |
Posted - 2007-07-05 : 10:56:47
|
| Ah yes, that resolved the issue :)Thanks!(probably should have known that, but I guess I never used them before or read about them)Question: What if I want to notify 3 or 4 people when something fails, how can I select multiple operators for a backup job, etc? |
|
|
|
|
|
|
|
|
SQL Agent can't "see" Database Mail profile