September 1, 2008 at 4:43 am
Hi i am getting this error when i try testing to send a email.
Date01/09/2008 11:23:09
LogSQL Agent (Current - 01/09/2008 11:23:09)
Message
[260] Unable to start mail session (reason: No mail profile defined)
Any ideas
September 1, 2008 at 4:59 am
Do you have a MAPI profile established on that server with Outlook installed? If not that is the first thing that needs to happen. In that process I alwasy try to be consistent with my profile names (typically leaving it as MS Exchange Settings) just so that I can use the same scripts on all servers.
Once that is established you should be able to run the following;
xp_stopmail
go
xp_startmail 'MS Exchange Settings'
go
If you already have a MAPI profile then insert the profile name in place of MS Exchange Settings in the above script. You can post the errors as a reply or search this site for more information on getting mail working.
If this is strictly for the Job Agent mail and not a sendmail statement within a job then you will have to right click on SQL Server Agent and make sure that you have the proper profile selected in there and restart SQL Server Agent once you have that setting correct. I believe there is an option to test that on the same tab.
It's been a couple of years since I have worked with 2000 so, my memory might be a bit rusty. Again, search this site as there is plenty of articles on configuring this.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 1, 2008 at 5:42 am
Thanks for the very detailed reply my mail session did not have the profile set to MS Exchange setting which you refred to in your reply. Am currently running a very important job at the moment and once it has complete i will set this setting to the profile name MS Exchange setting and test it.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply