Sending database mail alerts about upcoming birthdays?

There are in a database table - a list of employees in the company. Name | date of birth.

Is the idea to set up sending emails using db mail - when someone's birthday's coming up (for example next week) - staff letter.

The question of the person who is able to write only selects and inserts.
As Google to implement this idea? ))
August 23rd 19 at 10:47
1 answer
August 23rd 19 at 10:49
Solution
Well, as an option - googling unpleasant word blat (a command-line mailer) + xp_cmdshell

absolutely lap, but just to know how to write selects
thank you! - Angelita13 commented on August 23rd 19 at 10:52

Find more questions by tags SQL Server