Post reply

Email notification is failing when job is complete

  • September 10, 2003 at 12:11 pm

    #176707

    When a scheduled job is run I have set up the email notification to inform me if the job fails. This has just started to fail for some unknown reason. I checked the SQL Agent Log and it displays the following error:

    [264] An attempt was made to send an email when no email session has been established.

    I created a job that emails me a test message and that works, it';s the notification that is failing.

    I tested SQL Mail and it works fine.

  • September 10, 2003 at 12:43 pm

    #473519

    I don't think this is your problem but it may be worth checking the inbox/sent items (if you have quota's enabled on your server mail account), as it does fill up and gets to the state when no more emails can be sent.

    Steven

  • September 10, 2003 at 12:44 pm

    #473520

    When I stopped and restarted the SQLAgent it worked fine. Weird!

Viewing 3 posts - 1 through 2 (of 2 total)

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