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 |
|
racinghart
Starting Member
49 Posts |
 Posted - 2007-03-06 : 19:39:06
|
| within sql server management studio... we have set up a few sql scripts to run at 2am every night (sql server agent > under jobs)... although it has been successful each night, we'd like to setup sql server agent to automatically email success and failure notifications to our email boxes.i see under the properties of sql server agent > jobs > properties of a job > there is section that says Notifications but then it doesnt really have a place to type in which email we want to send them to? some reading material or instructions greatly appreciated |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-06 : 19:54:51
|
| You need to setup Database Mail plus setup an operator. Both of these can be found in the Management section IN SSMS.Tara Kizer |
 |
|
|
racinghart
Starting Member
49 Posts |
Posted - 2007-03-06 : 20:10:45
|
| thanks again Tara! |
|
|
|
racinghart
Starting Member
49 Posts |
Posted - 2007-03-06 : 20:25:13
|
| looks like i have to make an Exchange account for SSMS to use for such emailing. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-07 : 00:07:53
|
| No you don't. You only have to do that with SQL Server 2000, not with SQL Server 2005.Here's what we use in the Database Mail config:do_not_reply@ourDomain.comIt's not a real account.Tara Kizer |
|
|
|
racinghart
Starting Member
49 Posts |
Posted - 2007-03-07 : 18:15:54
|
| Ohhh i see what youre saying... so in SQL 2005 it only needs SMTP and does not rely on our exchange server. tomorrow i am being sent out to the location that needs this set up so i hope i can come right back in here and ask questions if i do not get it setup correctly. thanks again tara you are the goddess! lol |
|
|
|
|
|
|
setting up email notification in sql server mgmt