How to Send Mail Using SQL Server: Part 3

There are the following three parts of this tutorial:

  1. Configure email profile and send test Email using SQL Server.
     
  2. Select and send data in mail.
     
  3. Schedule daily mail from SQL Server

Introduction

This article explains how to schedule a daily mail from SQL Server 2008. To send daily email I will create a SQL Server Agent job to archive mail messages and after sending the mail I will also recode the Event Logs in a file.

Step 1

Log in to SQL Server 2008 with a correct user name and password.

Step 2

Expand SQL Server Agent then go to Jobs then right-click "New Job..." as in the following:

Job in Sql Server


Step 3

The following window appears, click on the General Tab first then Fill proper data then click on Steps .

New Job Wizard

Step 4

When you click on Steps the following window will appear:

Creating Steps in Job

When you click on "New..." it will go to the following window.

New Job Step Wizard

Provide the name of the steps and in the type dropdown select Transact-SQL Scripts then select the database and write the following scripts for the command:

  1. EXEC sp_send_dbmail @profile_name='MyTestMail',  
  2. @recipients='[email protected]',  
  3. @subject='My Test Mail Service with student data.',  
  4. @body='Hi This is daily Mail ',  
  5. @body_format ='HTML'  

 

Step 5

Then click on the OK button then go to the Schedules tab and you will find the following window.

Schedules in Job

Click on "New...".

Step 6

Then schedule the job by entering the reelvant information in the Schedules tab.

New Job Schedule

In this window set the occurrence, frequency, Schedule type, time to fire job, start date and end date and so on.

Then click OK. That's down. Our daily email scheduler is ready and will send mail daily at 08:00PM. Check the mail, it will show the data.

Summary

In this illustration you learned about configuring and sending daily email using SQL Server 2008. Please provide your valuable comments about this article.


Similar Articles