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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2013-03-18 : 14:05:28
|
| I want to add notification alerts when sql agent restarts.Do I need to add smtp role to my sql server.If I do not want to add this role Can I use an account set on our exchange server and how to use it to send notifications.If I used the sql database mail should I have smtp role added to the server.My server is a stand alone server not connected to the domain that has Exchange server.Thankssarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-18 : 14:15:09
|
| you can simply use Send Mail Task in SSIS it just requires connection to exchange server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-18 : 14:16:57
|
| The T-SQL equivalent is sp_send_dbmail------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Sending emails from sql server 2008