June 30, 2011 at 10:15 pm
how to configure mail alert in sql server 2008..?
June 30, 2011 at 11:01 pm
For what ??
June 30, 2011 at 11:02 pm
sql server job alert..
June 30, 2011 at 11:03 pm
job alert..when job is completed after that automaically send to mail..
June 30, 2011 at 11:25 pm
Coolroof (6/30/2011)
job alert..when job is completed after that automaically send to mail..
Do you have DB mail setup, Then use the notification and select the email option use whatever option you want.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 30, 2011 at 11:42 pm
thaks ii have configured but i check error log
SELECT * FROM msdb.dbo.sysmail_event_log
msg is
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-06-30T21:23:48). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it ipaddress with port no). )
June 30, 2011 at 11:48 pm
Coolroof (6/30/2011)
thaks ii have configured but i check error logSELECT * FROM msdb.dbo.sysmail_event_log
msg is
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-06-30T21:23:48). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it ipaddress with port no). )
It's look like you have some problem with firewall or port ect..
I have point out the errors in my bottom of the post
:Basic checks while setup the DBmail.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 1, 2011 at 5:30 am
thks now its working... before that i used sql server 2000 now i migrate to sql2008 so i need send mail same format without change script and without create profile..pls help..
July 1, 2011 at 5:34 am
how to use sp_send_cdosysmail format in sql server 2008..give me solution..
July 1, 2011 at 5:48 am
Coolroof (7/1/2011)
how to use sp_send_cdosysmail format in sql server 2008..give me solution..
http://www.sqlservercentral.com/Forums/Topic879554-391-1.aspx#bm879814
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 1, 2011 at 5:50 am
here not open this pages..pls provide how to use it..
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply