smtp in store procedure

Question

Post reply

smtp in store procedure

Ant-Green

SSC Guru

Points: 113566
More actions
August 20, 2020 at 12:51 pm
Answer
#3781924

You need to configure database mail via T-SQL or the GUI in the Management->Database Mail area.
The first hit in Jeff's link he kindly posted will point you to these three links on configuring database mail
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-database-mail?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/create-a-database-mail-account?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/create-a-database-mail-profile?view=sql-server-ver15

Then you call sp_send_dbmail with the right accounts/profiles needed to send mail

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

...smtp codes like we used to do earlier.

Earlier than when? What sort of SMTP codes?

Can you clarify a little?

Shree23 SSC-Addicted Points: 497 More actions · Answer 2

Normal means - smtp codes server name

like the below mention method but on the above code but in the above code i am unable to understand it.

https://www.sqlshack.com/configure-database-mail-sql-server/

could you please help me to understand from the code i posted how it going to send an email

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 3

I'll start off by saying that, once you've eliminated the double spacing, the first 463 lines of code are all a part of the dbo.sp_send_dbmail stored procedure, which is a system stored procedure that you must not change.

As for the rest of it, it's creating reports as to if and when backups were created and whether or not they were successful or not and then they each us dbo.sp_send_dbmail to send someone the report.

In order for this to work, you need to setup mail for the server. In order to do that, you're going to have to get with the folks in your infrastructure group and have them tell you what the smtp server name is and a couple of other things.

To do that, see the follow Google search page for help... you should go through it before you hit up the infrastructure folks for the smtp information I told you about above...

https://www.google.com/search?&q=set+up+mail+in+sql+server+2017

The link that you provided also has some good information in it but the smtp information you're looking for is esoteric to your company and the infrastructure folks that setup you email will have the information you need. If your email is in the cloud, then call your cloud provider for the information (the folks in infrastructure might also have that info so check with them first).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Shree23 SSC-Addicted Points: 497 More actions · Answer 4

Hi Expert,

My Question was where smtp it suppose to be configure or it is calling via some store procedure and how it is called from SP

Shree

Shree23 SSC-Addicted Points: 497 More actions · Answer 5

Shree23

SSC-Addicted

Points: 497

August 20, 2020 at 11:50 pm

#3782108

thank you so much for perfect answer!!