September 2, 2010 at 1:37 pm
Hi All,
i have a SP, which will do some update operations and send mail to respective users
to send mail i'm using msdb.dbo.sp_send_dbmail
when i execute this SP Query Analyzer it works fine and sends mail,
but when i incorporate this SP in SQL Agent as a nightly build process it's not working and doesn't sends mail
but executes successfully.
What's the issue
thanks in advance
Prakash.C
September 2, 2010 at 11:51 pm
Hi all,
no one has encountered such a problem yet....?
September 6, 2010 at 5:52 am
Can you fire the Job in day time and run a trace at the same time to see what's happening?
September 6, 2010 at 6:46 am
have you configured the correct operator in notification tab of sql job?
----------
Ashish
September 6, 2010 at 11:07 pm
prakashdotc (9/2/2010)
when i incorporate this SP in SQL Agent as a nightly build process it's not working and doesn't sends mail
Are you using the correct profile/account name ? i am sure not
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 11:31 am
My DBMail stopped working on 2 production servers after I upgraded to SQL 2012 SP1. It doesn't work from the query window or from an SQL job. It does work on the 2 corresponding test servers!? Same service pack was applied to all 4. Any ideas?
September 17, 2013 at 7:27 am
This won't be helpful per se, but recently I have an extremely difficult time trying to get the dbmail to work. I'd followed all of the steps, and had no issues on all but one server, unfortunately a production one. I looked through all the posts, and tried an uncounted number of things. One evening, it simply started working. One day I expect it will stop working, and I will have no idea why. Just maddening!
Good luck.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply