Questions tagged [senddbmail]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
84 views

SQL Server Management Send Mail as Part of a Job

I have a SQL Job that I would like to send an email through, but for some reason I can't get any details on why the email is not sending. This code works as expected when executed in the query window, ...
4
votes
1answer
229 views

SQL Server Long Running Transaction - WAITFOR(RECEIVE conversation…DatabaseMail)

I have recently implemented an Agent Job which checks SQL Server every 10mins for any long running queries and if detected it will send out a mail to recipients with the information. However since ...
-1
votes
1answer
21 views

How to report on how many emails have been sent by sql server for a given period of time?

Is there a good way to determine how many emails have been sent by sql server (sql notifications + invocations of sp_send_dbmail by applications) for a given period of time? Need this info for ...
1
vote
1answer
85 views

sp_send_dbmail: Failing When Adding Attachment

I have a simple script that should send an attachment using send_dbmail. It works when I exclude the attachment or send a very small file, e.g. 5KB. The prod file I want to send is 280KB. Exec ...
0
votes
0answers
121 views

Send email on postgres function

I'd like to incorporate this command line in a postgres 8.4 version function: echo "this is the body" | mail -s "subject" -r sender@sender.com "recepient@recepient.com" ...
0
votes
0answers
18 views

How send email with “execute as user”

I need that all my system users can send email from the DB. not to assign everyone the role in the msdb database I created one login/user "send_mail", and grant permission on msdb db, ...