SQl 2008 Database Mail Question

SQL 2008 64 Bit Enterprise
Windows 2008 Server 64 Bit
Three SQL database instances

I have database mail working great and has been since sql 2008 be running.

I made a change to the reply to email address save the database mail settings and restarted the SQL Agent,

But I still get the old reply to email address.

Also I setup a new maintenance  plain for a new database and all the jobs have notification set to send email to the operator only when job fails.
I am getting the email every time the job runs which is successful job ends.

Do I need to restart SQL?
Is there a tsql command I can run to check things?

Thanks

Tom
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
Is there a tsql command I can run to check things?
Have you tried:
EXECUTE msdb.dbo.sysmail_help_account_sp
0
 
Anthony PerkinsCommented:
Incidentally, the easiest way to change account information is using the system Stored Procedure:
sysmail_update_account_sp
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
Anthony

thanks for responding so fast

my results using the commands above match with what I entered using the SSIS


The second command sysmail_update_account_sp  failed did I miss something see below

EXECUTE msdb.dbo.sysmail_help_account_sp


account_id      name      description      email_address      display_name      replyto_address      servertype      servername      port      username      use_default_credentials      enable_ssl
1      SQLMAN      SQL Mail      support@mydomin.com      SQLMAN 2008      no-reply@mydomain.com      SMTP      serv005.our.network.mydomain.com      25      NULL      0      0


account_id      name      description      email_address      display_name      replyto_address      servertype      servername      port      username      use_default_credentials      enable_ssl
2      SQLMAN      SQL Email      support@mydomain.com      SQLMAN Sharepoint      no-reply@mydomain.com      SMTP      serv005.our.network.mydomain.com      25      NULL      0      0


account_id      name      description      email_address      display_name      replyto_address      servertype      servername      port      username      use_default_credentials      enable_ssl
1      SQLMAN      SQL Mail      support@mydoman.com      SQLMAN Wrestling      no-reply@mydomain.com      SMTP      serv005.our.network.mydomain.com      25      NULL      0      0



sysmail_update_account_sp


Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sysmail_update_account_sp'.



What I changed on the database mail was just the replyto email address  
saved and it still uses the old replyto
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
Thanks Anthony

I thought the emailaddress filed was the send to address but that is in the operator config
So I changes the emailaddress field in the database mail and now all good.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.