August 12, 2005 at 6:34 am
I have setup SQL Server Agent to use an Outlook Mail profile with POP3, not Exchange. When I created the mail profile, I used the same domain account that the SQL Server Agent runs under. I believe everything was working and now I have some problems.
Right now I can successfully start and stop a mail session by doing the test within SQL Server Agent Properties. However, if I send a test email to an operator or if one of my SQL Server Agent job fails I am not being notified.
If I log into the server with the domain account SQL Server Agent is using and open Outlook I receive the following error message: "Unable to open your mail default e-mail folders. The file C:\....\outlook.pst is in use and could not be accessed. Close any application that is using this file, and then try again."
If I stop the SQL Server Agent and I re-open outlook, I do not receive any error messages and I will receive my test messages that I had previously sent from SQL.
It appears there is a conflict between the SQL Server Agent and Outlook. I tried creating a new mail profile and setting up SQL to use that with no luck.
August 12, 2005 at 7:56 am
While this means setting up some things manually I recommend downloading and using SMTP Send Mail which is available at http://sqldev.net/xp/xpsmtp.htm. I have had multiple problems using SQL Mail and SQL Agent Mail, but this far SMTP Send Mail has been bullet proof.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 12, 2005 at 8:09 am
I think I renamed the .pst file, and then it created a new one which fixed the problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply