May 7, 2003 at 12:48 pm
Using SQL Server 2000, set up email and tested OK using a simple Maintenance Plan (Optimize 2 DBs). The Plan completes and the email is sent. Next, I created a Plan with a recurring optimization (every 15 minutes) and a full backup to be run on Sundays at 3:00 AM. The optimizations run but no email is sent. When I try the Test button (in MaintPlan Properties) for email notification I get <<< Error 22022: SQLServerAgent Error: The file C:\...\mailbox.pst could not be accessed because another workstation has modified it. Close and then restart all mail-enabled applications. >>>
It seems like the only thing that clears this error is to reboot.
COULD THIS BE A BUG???
May 7, 2003 at 12:58 pm
This is a MAPI issue and can occur in Outlook as well, so it's not specifically a Maintenance Plan issue. Is there a reason you are using Personal Folders (which is represented by the .pst)?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 7, 2003 at 1:07 pm
Ignorance is my only defense - Should I avoid Personal Folders, if so, how do I remedy this?
May 7, 2003 at 2:09 pm
One of the DBAs in my environment has configured SQL Mail w/ Personal Folders. If you set it up right, this means SQL Mail won't fail if the Exchange Server is temporarily unavailable... but he's yet to write an article about it (though he's been prodded to). I'll see if I can get Void to post the high points of his solution.
Out of curiousity is there a possiblity you have more than one SQL Server hitting this particular personal folder or are you accessing it with Outlook at the same time?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 7, 2003 at 2:39 pm
Only 1 instance of SQL Server and Outlook is NOT running. Maybe I should set the Delivery option in the mail profile to <None> instead of Personal Folders.....?
May 7, 2003 at 2:46 pm
Well, for simplicity sake, set the delivery point to Mailbox - XXX. Then open Outlook (or excange client) on the server and let it remap your folders and inbox. This doesn't buy you anything as far as reliability is concerned, however, it should solve your issue.
If you WANT to use personal folders, let me know and I'll try to respond when I have more time. Using personal folders will allow your SQL Server to cue up e-mails in your outbox when the exchange server is unavailiable, and send them when exchange comes back on-line.
May 8, 2003 at 7:51 pm
Void,
Could you please make the post. We are running about 6 installations of SQLServer and use 1 mailbox only for all emails from SQL. Our sysadmin team are updating to exchange 2000 and therfore the mail server is continually going down, thus breaking some of our batch jobs overnight. I love getting the email message saying the job failed as it couldn't send an email, so anything that can help us alleviate the problems would be muchly appreciated.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply