| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2004-10-21 : 13:49:45
|
| I want to make SQL-Server send me email. I have installed Microsoft Outlook 2000. I have created Mail profil. I have set SQL Mail and SQL Server Agent mail. MS Outlook sends email successfully. The problem is that SQL Server and MS Outlook have problem using a .pst file. Whoever uses the file first, the other one generates an error which says the file is in use by another application.Even when I test sending email or paging an operator (when SQL server has been run first), then SQL Server sends the email but I don't recieve until I stop SQL server, then run the MS Outlook on the server. A few minutes later I have the emails in my mail box and a message on my cell.What's wrong? What should I do?Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-21 : 16:28:22
|
| Does xp_sendmail work?Tara |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-22 : 09:31:27
|
I ran the xp_sendmail and got "Mail sent". But I have no idea where the message was sent. Even when I used a dummy recipent, in result pane got "Mail sent". Is that ok?quote:
Originally posted by tduggan
Does xp_sendmail work?Tara
Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-22 : 12:23:56
|
| Yes. It doesn't know that it actually got delivered, just that it was sent. Did it make it through Exchange?And it sounds like SQL Mail is in fact working.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-23 : 14:02:39
|
| Here's a silly question. Why do you have Outlook using a pst file?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-25 : 07:26:52
|
I don't have Exchange. I have Microsoft Outlook. My tests show that the mails sent by SQL are accumulated somewhere and when I run the Outlook, it sends them to recipient.What is mail profile? Should I create different mail profile?quote:
Originally posted by tduggan
Yes. It doesn't know that it actually got delivered, just that it was sent. Did it make it through Exchange?And it sounds like SQL Mail is in fact working.Tara
Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-25 : 07:27:51
|
What should I do? Please give me your solution. quote:
Originally posted by derrickleggett
Here's a silly question. Why do you have Outlook using a pst file?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
Canada DBA |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-26 : 08:46:55
|
| My problem is solved. I ran the MS-Outlook on the server box itself and then locked the computer. Now, the SQLAgent's test sends a test to my email.Also successful jobs send me an email. Before this, I was working through Terminal Services and had mentioned problems. Although MS-Outlook was not running on the server box, but when I was going to run in it through Terminal Services, I recieved and error indicating the pst file is in use by another application while when I ran the MS-Outlook in the server box itself, I didn't get any error and it is working now. Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2004-10-26 : 13:53:48
|
Sounds good. I am going to test it. Having your SP, do I still need the aspMail? And is it a service or I have to login to the server and leave it while running the aspMail. It is what I am doing with Outlook. quote:
Originally posted by Lumbago
SQL mail sux...use this instead, works like a charm:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36293--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand"
Canada DBA |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-10-26 : 17:23:43
|
| Aspemail is free and runs as a service...install it through TS on the server, make sure you can access an smtp from there and you're set to go.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
SQL Mail