What the below code is performing?

USE msdb

EXEC msdb..sp_send_dbmail
@profile_name='Test Cient',
@recipients='receipent1@yopmail.com;receipent2@yopmail.com', @subject='Daily File Report',
@body= 'Please find enclosed the daily file report',
@file_attachments='D:\FileToExport.txt'

 Posted by Rajnilari2015 on 1/24/2016 | Category: Sql Server Interview questions | Views: 415 | Points: 40
Answer:

The above code will send email using the sp_send_dbmail of MSDB which will reach to the recipients receipent1@yopmail.com;receipent2@yopmail.com with the subject as 'Daily File Report' , the body being 'Please find enclosed the daily file report' and a file attachment 'D:\FileToExport.txt'


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response