Link to home
Start Free TrialLog in
Avatar of kblau
kblau

asked on

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

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.
Avatar of lcohan
lcohan
Flag of Canada image

"calling c# assembly which calls sproc " - what SQL login IS calling the SP in this case?
ASKER CERTIFIED SOLUTION
Avatar of kblau
kblau

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kblau
kblau

ASKER

did own research