Job Scehdule in Sql server usinh Sql Server Agent

Set up Mail in SQL

Create a Database Mail Profile

Create a Database Mail Account

Config the Account

Send a test Email using SP

Call the SP using SQL Agent

https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/create-a-database-mail-profile?view=sql-server-2017

0

Hello

Check these Links

https://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx

https://www.youtube.com/watch?v=5UGavvH3Nj4

https://www.sqlshack.com/have-your-database-server-talk-to-you-send-emails-directly-from-sql-agent-jobs/

https://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/

0

You may follow the steps mentioned in the below link.

https://docs.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-2017

0