Solved

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

Posted on 2013-01-14
3
476 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 39

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

810 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