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
2 answers

dbMail concatenated url parsing ampersand as word and

I'm using dbmail to gather data and send an email. As a part of that email, I have a url surrounding text for a clickable link to an SSRS report with parameters. If I only have one parameter, I'm fine. But, if I add parameters, the url is passed…
Janet Barnett
  • 111
  • 1
  • 7
0
votes
1 answer

dbmail is stopping sometimes in sql

sometimes dbmail in sql stops sending emails with this error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2018-05-07T08:54:34). Exception Message: Cannot send mails to mail server.…
Shams7353
  • 11
  • 2
0
votes
1 answer

need to recreate sp_send_dbmail in msdb system procedure folder

We have a SQL Server 2008 system. Somehow the sp_send_dbmail sproc got deleted from msdb. When I recreate the sproc, it does not get put in the system folder and gets put in the general sproc folder of msdb. Anyone know how to move the sproc or…
mson
  • 7,762
  • 6
  • 40
  • 70
0
votes
1 answer

T-SQL Dbmail ignore error/send email with/without attachment (dynamic email)

I wrote a quick query which pulls out information from the system and puts it into an email when a task is completed. Each task has a numerical id, and that is the key link between data and my attachment. The email runs the query for example on…
Alphaturian
  • 25
  • 5
0
votes
0 answers

dbmail @reply_to

I don't think I'm going to have much joy with this question but I can't see anyone has asked for a while... Is there a way around the one email address limitation for the @reply_to in dbmail? I'm wanting to group on average have a dozen addresses…
IchBinDicky
  • 57
  • 8
0
votes
1 answer

Inserting Image to HTML table within SQL Server stored procedure for use with DBMail

I want to add an icon/image within a column of a table which is populated with SQL Server table data & the resulting emailed out. As it stands all I'm getting in the email is My code: --Full path set within…
IchBinDicky
  • 57
  • 8
0
votes
1 answer

How to create view and trigger

I am attempting to send a notification email she n a running total reaches or passes a set value (like a sales goal announcement)..: I have the query to get the running total: DECLARE @TBL TABLE(id int, amount int); INSERT INTO @TBL VALUES (1,…
Nick
  • 3
  • 1
0
votes
1 answer

SQL Server running total with dbmail when total met or exceeded

I am able to get a running total via script--but what I can't seem to do is isolate the line where I have met or exceeded a certain value... SELECT column1, (SELECT SUM(column1) FROM table WHERE column2 <= t1.column2) FROM table t1…
Nick
  • 3
  • 1
0
votes
1 answer

How can I create an object of Microsoft.SqlServer.Management.Smo.Mail.MailServer class?

I am trying to create an object of Microsoft.SqlServer.Management.Smo.Mail.MailServer class in PowerShell. The reason I need to do this is because I am trying to setup DBMail on the fresh instance of SQL using PowerShell. I am successfully able to…
Ankush Gupta
  • 205
  • 5
  • 14
0
votes
1 answer

SQL Split text from column in several lines in select statement

I'm creating a job in SQL Server 2014 and the last step is to send the output of the first step to my email. I'm already sending the email with the result of the next query: select TOP 1 msdb.dbo.agent_datetime(run_date, run_time) as…
patricia
  • 1,075
  • 1
  • 16
  • 44
0
votes
2 answers

send mail SQL Server with Dynamic smtp

That's basically it. i've configured the profile, mail, smtp server, username and password. I'm using sp_send_dbmail but occasionally I'm going to change the smtp, username, password and port, I have that in a table and I just need to the pass…
Carlos Anez
  • 61
  • 1
  • 11
0
votes
1 answer

Create PDF document in SQL

I am writing a stored procedure in T-SQL that sends mail. I am looking to add an attachment to these emails. I have an html string that I would like to convert to pdf and attach to my email. I am using selectPDF to convert my html to pdf. Can this…
Diane2
  • 160
  • 3
  • 16
0
votes
2 answers

SQL Job (Send Mail) - error formatting query probably invalid parameters

I know this has come up a lot in the past but none of the fixes I've Googled or found on here has worked for me in this instance. I'm running a fairly standard SQL Server Agent Job as a Transact-SQL script with the follow details: (replaced some…
David T
  • 1
  • 1
0
votes
2 answers

Database mail messed up CSV attachment

Is there any way to format output CSV from below statement to be easily readable by Excel? As for now it opens all columns messed up into one column. I have tried already different deperators. EXEC msdb.dbo.sp_send_dbmail @profile_name =…
user4778
  • 53
  • 1
  • 1
  • 5
0
votes
2 answers

Steps to create a sql server agent job to send emails daily

I have a query to retrieve the email ids from my demo table. I have also configured database email on my sql server. But I am new to sql server agent jobs. I want to send reminders to people who havent filled there daily task report at a specific…
Manish
  • 21
  • 1
  • 9
1 2
3
4