Post reply

the job succeeded .. failed to notify 'vinay' via email..'

  • October 12, 2012 at 6:17 am

    #393375

    I was looking in google to reslove this but i didnt find the solution..

    I am attaching sysmail_mailitems

    11Vinay.Varala@vianetfs.comNULLNULLDatabase Mail TestNULLNULLThis is a test e-mail sent from Database Mail on SQL-VFS01-VM.TEXTNORMALNORMALNULLMIMENULLNULL01256 002012-10-10 16:41:42.557fmNULL22012-10-12 10:23:16.7532012-10-12 10:23:16.760fm

    I am attaching msdb.dbo.sysmail_log

    232012-10-10 16:41:48.370The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-10-10T16:41:47). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it 172.20.10.61:25). )15721NULL2012-10-10 16:41:48.370sa

    and finally in log file viewer

    the job succeeded .. failed to notify 'vinay' via email.'

    can any one help in get rid of this many thanks.

  • October 12, 2012 at 6:27 am

    #1548590

    Looks like Database Mail isn't correctly configured. There's plenty of information out there on how to set it up - here[/url]'s an example.

    John

  • October 12, 2012 at 7:46 am

    #1548645

    Hi

    I tested by sending sample email its works fine..

  • October 12, 2012 at 8:11 am

    #1548664

    OK, then you need to provide more information. Was this a one-off failure, or does it happen regularly? Does it always happen at the same time of day? Was your test mail sent using the same mail profile as your alert system uses? And so on and so on. You need to find what's different between the one that worked and the one that failed.

    John

  • October 12, 2012 at 9:37 am

    #1548732

    I didnt create alert system do I need to create it ..

    I follow this procedure

    . configure database mail

    . test by sending sample mail

    . change the properties of server agent .

    .restart the server agent

    .created operator.

    . in job notification i used that operator.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply