Configured by the "Database Mail Configuration Wizard": SMTP accounts, security settings, system parameters ...
sysmail_delete_mailitems_sp -- houeskeeping typically based on sent_before (i.e. date sent) and sent_status (e.g. has the mail been 'sent')
sp_send_dbmail -- stored procedure to send email
NB The older SQL Mail was based on MAPI profiles and is harder to configure and administrate - Database Mail was introduced in SQL2005
No comments:
Post a Comment