sql - Database Mail not sending -
i'm trying send email using databasemail on sql server 2008; can see emails sitting in msdb.dbo.sysmail_unsentitems
but sit down there , no error messages. i've checked , have rights utilize databasemail using following:
exec msdb.sys.sp_helprolemember 'databasemailuserrole';
and tried running
exec msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';
which shows length number of emails i've tried send, status showing inactive.
am missing else?
sql sql-server
No comments:
Post a Comment