Sql server Database Mail EXECUTE msdb dbo spsenddbmail

Sql server Database Mail

�EXECUTE msdb. dbo. sp_send_dbmail �@profile_name = ‘HRMail’, �@recipients = ‘Gregory. House@adventureworks. com’, �@copy_recipients = ‘Administrator@adventureworks. com’, �@body = ‘Your data has been successfully imported!’, �@subject = ‘Import Notification Message Success’;

� � � � EXECUTE msdb. dbo. sp_send_dbmail @profile_name = ‘HRMail’, @recipients = ‘Lisa. Cuddy@adventureworks. com’, @blind_copy_recipients = ‘Gregory. House@adventureworks. com; Administrator@adventureworks. com’, @body = ‘Per your request, here are the employees hired in 2002. ’, @query = ‘SELECT Person. First. Name AS First, Person. Last. Name AS Last, Human. Resources. Employee. Hire. Date AS [Date of Hire] FROM Person INNER JOIN Human. Resources. Employee ON Person. Business. Entity. ID = Human. Resources. Employee. Business. Entity. ID WHERE Hire. Date > ‘’ 2002 -01 -01" AND HIREDATE < ‘’ 2003 -01 -01’’ ORDER BY Hire. Date’, @execute_query_database = ‘Adventure. Works 2008’, @subject = ‘Employees Hired in 2002’, @attach_query_result_as_file = 1;

Managing Messages �SELECT * FROM msdb. dbo. sysmail_mailitems �EXECUTE msdb. dbo. sysmail_delete_mailitems_sp �@sent_before = ‘January 31, 2009’ ; �EXECUTE msdb. dbo. sysmail_delete_mailitems_sp �@sent_status = ‘failed’;

�sp_send_dbmail @profile_name, @recipients, @copy_recipients, @blind_copy_recipients, @subject, @body_format, @importance, @sensitivity, @file_attachments, @query, @execute_query_ �Database, @attach_query_result_ �as_file, @query_attachment_ �filename