Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    169

    Unanswered: Job notification

    Morning all!

    My SQL server email job notifications have stopped working, but mails sent through the xp_sendmail command still work.

    The only thing that has changed recently is the SQL server agent account passwords have been changed, these accounts are normal win2000 domain accounts.

    Any ideas cos I am fully stumped?

  2. #2
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34

    Question

    Have you tried testing the SQLMail Profile?

    Support Services/SQLMail.

    Are SQLMail and SQLAgentMail using the same mail profile?

  3. #3
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Already tested the SQL mail profile and that works ok,


    How do I check which profile the sqlagentmail is using?

  4. #4
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34
    Originally posted by SQLSlammer
    Already tested the SQL mail profile and that works ok,


    How do I check which profile the sqlagentmail is using?
    Right click on SQL Agent/Properties and check that it is using the same mail profile.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •