Stack Overflow
Stack Overflow

Questions tagged [dbmail]

DBMail is an open-source project that enables storage of mail messages in a relational database. Currently MySQL, PostgreSQL, Oracle, and SQLite can be used as storage backends. Commercial development and support is also available.

DBMail is an open-source project that enables storage of mail messages in a relational database. Currently MySQL, PostgreSQL, Oracle, and SQLite can be used as storage backends. Commercial development and support is also available.

FROM: http://www.dbmail.org/

54 questions
0
votes
0 answers

SQL database Mail Password change permissions

SQL Server 2005 / SQL Server 2008 R2 I have to make use of email accounts with Database Mail whose passwords have a life of 90 days so therefore have to ensure that smtp Authentication passwords are updated in a timely fashion. I currently have a…
Will Kyle
  • 1
  • 1
0
votes
2 answers

I want to send dbmail showing the number of affected rows after an update sql agent job runs

I have a SQL agent job that runs several UPDATE statements. What I want is to have it send of an email after it runs everyday. I get the emails but it doesn't show the number of rows affected or anything. Here is what I have. --Print…
BSanders
  • 295
  • 1
  • 6
  • 29
0
votes
1 answer

Format / Indent XML code while sending email using sp_send_dbmail [formatting xml code in mail body]

I am trying to send a dbmail with XML code as a body, see my code below showing the same, declare @xml xml = ' 2003/07/04 123 Acme Alpha …
Dineshkumar
  • 11
  • 4
0
votes
0 answers

SQL server 2008 DB mail sending Fail Issue

I have Created Profile and Account in My server. While sending a test mail it Throws an error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2013-05-30T19:07:28). Exception…
Jigneshal
  • 1
  • 1
0
votes
2 answers

Send db mail task fails in SSIS Package with errors related to the parameter

I am trying to execute this sql task in SSIS package which send an email when the file name is not found. I have declared this user-defined variable "@PackageStartTime" in my ssis package. But when my SSIS package hit this task it fails with…
ETLUser
  • 371
  • 4
  • 7
  • 19
0
votes
0 answers

dbmail email from cmd

Is it possible to send email attachment using dbmail from cmd? I'm using a batch file to send email attachment using dbmail but getting an error. Here is my code: sqlcmd -q "EXEC msdb.dbo.sp_send_dbmail @profile_name = 'ProfileName', …
Liton Uddin
  • 85
  • 1
  • 11
-1
votes
1 answer

Format msdb.dbo.sp_send_dbmail

--SQL format Declare @body As nvarchar(max)=N'' +N'

Hi '+@userId+'

New amendment for act '+@title+' is added' +N'

This amendment include changes to the Section: '+@sectionid+' and Title:…

Mohammad Asif
  • 1
  • 2
-1
votes
1 answer

DB Mail is working with other carriers but not sprint

So the database mailer sends the sms to Verizon, att, Cricket etc.. but when sending to a sprint phone number using messaging.sprintpcs.com they receive a text with what looks to be the message encrypted. We have tried with with different sprint…
Tyriddik
  • 104
  • 1
  • 6
-1
votes
1 answer

adding dynamic content within body of an email (database mail) with sp_send_dbmail

Is there a way I can add the time in the following query as the body of my email : EXEC msdb.dbo.sp_send_dbmail @profile_name = 'TEST_DEV', @recipients = 'xxx@gmail.com', @query = ' select Percentage =…
CodeNinja
  • 3,188
  • 19
  • 69
  • 112
1 2 3
4