Send automated and scheduled emails in SQL Express

[@datafriendly]

Procedure for account creation:
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'Email',
@description = 'Sent Mail using MSDB localhost',
@email_address = '[e-mail]',
@display_name = 'Name',
@username='[e-mail]',
@password='xxxxxxxxxxxxxxx',
@mailserver_name = 'outlook.office365.com',
@port = '587',
@enable_ssl = 1

EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'Email',
@description = 'Profile used to send mail'
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'Email',
@account_name = 'Email',
@sequence_number = 1
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'Email',
@principal_name = 'public',
@is_default = 1 ;
SELECT * FROM msdb.dbo.sysmail_log
GO

[@in-litedesign4391]

Could you please show the CREATE PROCEDURE Code as well.

[@gambu4810]

A good teacher doesn't say, I've already executed that part. He actually shows the execution and every step of the lesson. Thank you so much good Sir, however.

[@datafriendly]

Glad it was helpful! There is a script for that part in the pinned comment.

[@luke2042]

Very nice. Thank you.

[@sambhunathchakraborty]

superb..........BOSS

[@datafriendly]

Thanks

[@ukaszbinkowski2197]

Thank you so much for this video , You helped me so much at my work !!!!!

[@datafriendly]

Glad I could help!

[@amrselim2167]

Great man

[@datafriendly]

Thanks

[@akshaykumarng3013]

Nice 👍

[@anu8419]

Thankyou so much for this video...it's really very helpful...could you please tell instead of table, if i use stored procedure , so how to declare variables in the query for stored procedure

[@datafriendly]

Not sure, need to check.

[@Harziona]

Thanks so much for sharing. It's really helpful

[@datafriendly]

Glad it was helpful!

[@xenias1509]

Great Information! If I had a schedule my SQL job every 15 min, 'if exist' then send an email. But I want to receive the email once with the same row, is there any way to manage it? Something like if it was sent before then don't send...I got the same email every 15 min..it's distracting. Thank you in advance.

[@datafriendly]

Hi, I haven't done this yet, so I'm not sure about that. I'll let you know once I find how to do that.

[@loveofkaranpreetha9317]

one doubt on the above video
you explained everythink but one think you forgot which is how to create procedure for creating account,profile,..
if you see my comments could you please share that sp

[@datafriendly]

Here you go:
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'Email',
@description = 'Sent Mail using MSDB localhost',
@email_address = '[e-mail]',
@display_name = 'Name',
@username='[e-mail]',
@password='xxxxxxxxxxxxxxx',
@mailserver_name = 'outlook.office365.com',
@port = '587',
@enable_ssl = 1
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'Email',
@description = 'Profile used to send mail'
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'Email',
@account_name = 'Email',
@sequence_number = 1
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'Email',
@principal_name = 'public',
@is_default = 1 ;
SELECT * FROM msdb.dbo.sysmail_log
GO

[@in-litedesign4391]

@@datafriendly Hey did you get the CREATE SP code?

[@in-litedesign4391]

did you get that code?

[@Mihaihunter]

I have a question. I cannot see the table on my outlook window. I tried to uncheck the message format options that removed the format of messages. Still not working. Any ideea why i still see the html code?

[@datafriendly]

Might be the issue with your e-mail client. Or some mistake in the code itself.

[@napathelu]

Is is possible to do the same in Oracl sQL developer

[@datafriendly]

I don't think so.

[@PhươngThảoNguyễn-b1b]

How to send the procedure result via email?

[@datafriendly]

It was mentioned in the video, please take a look again.

[@osnlearn8034]

lets go to the gym and doin martial art. learn islam go to mosque, change your habit,and become human as ALLAH want it. become expert programmer or anything else for Allah. dont be perfect. just calm down and always pray to Allah.

[@datafriendly]

?

[@kihramcizadegiller]

i always get an error.. database mail settings true.
The mail could not be sent to the recipients because of the mail server failure.
(Sending Mail using Account 11 (2023-09-13T13:10:15). Exception Message: Cannot send mails to mail server. (Failure sending mail.)

[@ammarfaqih6919]

Please explain how to send a voucher or voucher to a customer via WhatsApp from SqlServer

[@datafriendly]

Sorry, but my channel is crypto oriented now, I don't make videos about SQL anymore.