July 30, 2008 at 2:43 am
Dear All,
I have setup data replication in SQL Server 2005. I want to get the email alert after the job completion. I have create one operator with my email id. The Job notification set with mail & that operator.
I have installed the SQL server with my user id & outlook is also configured in my account. I'm able to set the SQLMail with my default Outlook account & able to send mail using the xp_sendmail stored procedure. but the job completion is not triggered the email.
I checked the 'net send' & windows application event log, those are perfect.
Do i need to set up the Database Mail? if yes then anyone help me to setup with my default outlook account...
I have attached the screen shots here...
July 30, 2008 at 4:27 am
In SQL 2000 you can configure SQL Mail, which is used when executing xp_sendmail and SQL Agent Mail, which is used to send job notifications. You can set the profile for SQL Agent Mail by opening the properties for the SQL agent.
Hope this helps.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply