April 24, 2004 at 12:33 am
i have created one job which will take daily backup from the server at 12:00 pm, but now what i want is that it will send me an notification email, after it completes the backup, so i tried notification option.
after clicking on the email operator i added 1 operator, and after specifiying email address when i test, it showed following err message.
i dont know what is the reason behind i have configured my outlook express to some pop3 email and it works fine, and i thought sql server will use tht pop3 mail alc for sending email, but its not working , anybody know why is that
Following is the Err message
-------------------------------------------
Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is
not running check the mail profile and /or the sqlSERVER Agent SERVice startyp Account in the SQLSERVERAgent Properties dialog
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
April 24, 2004 at 3:00 am
You need to create what is called a MAPI profile for SQL Server to use for SQL Server Agent. Unfortunately, Outlook Express does not create a MAPI profile. Full blown Microsoft Outlook does.
Setting up SQL Mail can often be a chore and Microsoft has produced a series of KB articles that detail what you have to do a lot better than what is in Books Online:
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply