Tuesday, 15 September 2015

sql - Database Mail not sending -



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