Thread: automated email
View Single Post
Old 06-13-2019, 01:03 PM   #6
supmktg
Newly Registered User
 
Join Date: Mar 2002
Posts: 357
Thanks: 34
Thanked 3 Times in 3 Posts
supmktg
Re: automated email

I've discovered that Azure SQL no longer includes SQL Agent. For others that happen upon this post, my research found 2 alternative methods to send a scheduled email from Azure:
https://vpolizzi.wordpress.com/2010/...-on-sql-azure/
https://docs.microsoft.com/en-in/azu...-to-send-email

I may try this at a later date, but for now I will most likely have my Access app send the email on the first user shutdown after 4:30pm, and log it into a sent mail table so no further emails will be sent for that day, or send it upon the first login in the morning of the next day. It is not optimal, but it is my best choice for now.

Thanks to both of you!
Sup

If someone has a better idea, I'm all ears!
supmktg is offline   Reply With Quote