Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sp_send_dbmail works if tsql job agent calls tsql, but does not work if assembly called

Posted on 2013-01-14
3
Medium Priority
?
488 Views
Last Modified: 2013-01-20
real simple.  sa is owner in both cases
i have tsql job agent calling sproc directly with sp_send_dbmail, works beatifully.
i have tsql job agent calling c# assembly which calls sproc with sp_send_dbmail, now sp_send_dbmail not working.
0
Comment
Question by:kblau
  • 2
3 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 38779214
"calling c# assembly which calls sproc " - what SQL login IS calling the SP in this case?
0
 
LVL 5

Accepted Solution

by:
kblau earned 0 total points
ID: 38779383
think i figured out the problem in theory, no have time to test.  need DatabaseMailUser role for user that calls into sproc (connection string)
0
 
LVL 5

Author Closing Comment

by:kblau
ID: 38798083
did own research
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question