Questions tagged [database-mail]

is a component of Microsoft SQL Server for sending e-mail messages.

Database Mail is a component of Microsoft SQL Server for sending e-mail messages directly from the SQL Server Database Engine.

95 questions
0
votes
1 answer

SQL Database Mail from Azure VM

We're migrating our system from dedicated hosting to Azure. Part of this process is a data feed system that emails clients and our system admins when there are issues with the data feeds. We use SQL Database Mail and a simple IIS 6.0 SMTP server set…
0
votes
0 answers

SQL Database Mail Failure Results in Duplicate Emails

I have a job set up on SQL Server 2012 to send weekly emails to specific recipients, and I am diagnosing an issue where users have been receiving duplicate emails. I have traced the issue back to a BCC recipient that is no longer with the company…
Kevin
  • 172
  • 1
  • 12
0
votes
0 answers

How to use SQL Database Mail to send email to different recipients for each contract expiring on the same day

Given a table containing 'CompanyName', 'ContractExpirationDate', and 'EmailAlertAddress' where there may be more than one ContractExpirationDate on the same day, i.e. More than one company's contract may expires on the same day. And, each company…
David Megnin
  • 79
  • 1
  • 1
  • 10
0
votes
1 answer

SQL Server Database Mail: HTML not rendering in Outlook and gmail

I am using Database Mail in SQL Server and trying to send emails. I have created this simple html message for testing purposes: declare @body nvarchar(1000) select @body = '

Test Email

Hussein Salman
  • 7,806
  • 15
  • 60
  • 98
0
votes
1 answer

SQL Database Mail not sending with certain profile

I am trying to get SQL database mail to send emails using a new db mail profile and account. The new db mail profile and account that I am creating uses the exact same server name as the old db mail profiles and accounts on our server. Whenever I…
Connor Williams
  • 319
  • 2
  • 13
0
votes
0 answers

SQL Email Tabular Format giving Scientific Values instead of fixed decimals

I have a query that sends the results to my email in a tabular format. I am using this link as a reference. https://www.mssqltips.com/sqlservertip/2347/send-email-in-a-tabular-format-using-sql-server-database-mail/ I am able to successfully send…
ENGR024
  • 307
  • 1
  • 13
  • 33
0
votes
0 answers

Collecting Weekly Data for Database Mail

I have an SQL table that represents the material currently committed to a job. Whenever a job is completed the data is removed, as we only want long-term records of the final material used. The problem is that we now want to get the Job Number and…
Justin Burgard
  • 440
  • 1
  • 6
  • 17
0
votes
1 answer

sp_notify_operator: The specified @operator_name does not exist (but it does!)

OK, so I think I'm going mad here! Here's where I am. SQL Server 2008: I've set up Database Mail, and I've sent myself a test email. Simple, works fine. I've created an operator, called 'Tom'. I've given it an email address (but nothing…
Tom Morgan
  • 2,355
  • 18
  • 29
0
votes
1 answer

SQL Server 2012 Job Failure - send email

After doing some research here and elsewhere, and trying a few troubleshooting attempts, I come to you good folks for help. In SQL Server 2012, I have a job, with (currently) only one step. That step goes something like this: EXEC…
0
votes
1 answer

Time out error in Database mail

I'm taking database backup every day, with job of course. But now I want to send that backup file to another place and want to use for that Database mail. I configured Database mail and can send files with size less than 10 MB (at least I tested up…
Elvin Ahmadov
  • 536
  • 5
  • 10
0
votes
1 answer

How to configure and run database mail in SQL Server

How to enable and run database mail in SQL Server 2008? I know that it need to Enabling Service Broker Configuring SMTP (a Mail server is needed) Using configuration stored procedure I don't know what's the relation between application and…
Nasser Hadjloo
  • 12,312
  • 15
  • 69
  • 100
0
votes
2 answers

SQL Server 2008 database mail using YANDEX

I am trying to send mail with my yandex mail account on database mail. Actually it was working for a long time. Last 1 month I cannot send mail with my yandex account. Always it gives that error message, Error,16492,The mail could not be sent to…
0
votes
1 answer

Setting up SQL Server 2012 database mail to use SendGrid

I have been trying all afternoon to get SQL Server 2012 database mail to use smtp.sendgrid.net to send email. I just keep getting this error no matter what I try: The mail could not be sent to the recipients because of the mail server failure. …
RuSs
  • 1,725
  • 1
  • 29
  • 47
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
0
votes
1 answer

email notifications from SQL Server job

We want to set a profile in Database Mail on SQL Server 2008 R2 for all the developers in our team to receive notifications once an overnight job has completed. Unfortunately, in the Notifications properties in the job it only allows us to select…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148