在SQL Server 2005中使用和管理数据库邮件

-- Create a Database Mail profile 
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = "Database Administration Profile",
@description = "Mail Profile for use by DBA processes";

-- Add the account to the profile 
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = "Database Administration Profile",
@account_name = "Database Administration Account",
@sequence_number =1 ;
-- Grant Access to the profile 
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = "Database Administration Profile",
@principal_name = "ProdServer01",

sp_send_dbmail [ [ @profile_name = ] "profile_name" ]
[ , [ @recipients = ] "recipients [ ; ...n ]" ]
[ , [ @copy_recipients = ] "copy_recipient [ ; ...n ]" ]
[ , [ @blind_copy_recipients = ] "blind_copy_recipient [ ; ...n ]" ]
[ , [ @subject = ] "subject" ]
[ , [ @body = ] "body" ]
[ , [ @body_format = ] "body_format" ]
[ , [ @importance = ] "importance" ]
[ , [ @sensitivity = ] "sensitivity" ]
[ , [ @file_attachments = ] "attachment [ ; ...n ]" ]
[ , [ @query = ] "query" ]
[ , [ @execute_query_database = ] "execute_query_database" ]
[ , [ @attach_query_result_as_file = ] attach_query_result_as_file ]
[ , [ @query_attachment_filename = ] query_attachment_filename ]
[ , [ @query_result_header = ] query_result_header ]
[ , [ @query_result_width = ] query_result_width ]
[ , [ @query_result_separator = ] "query_result_separator" ]
[ , [ @exclude_query_output = ] exclude_query_output ]
[ , [ @append_query_error = ] append_query_error ]
[ , [ @query_no_truncate = ] query_no_truncate ]
[ , [ @mailitem_id = ] mailitem_id ] [ OUTPUT ]

EXEC msdb.dbo.sp_send_dbmail
@profile_name = "Database Administration Profile",
@recipients = "greg.larsen@databasejournal.com",
@body = "Reindex database process completed successfully",
@subject = "Reindex Database" ;