Post reply

getting a email delivert status when sending email using msdb.dbo.sp_send_dbmail

  • August 24, 2010 at 3:14 am

    #228264

    Hi All,

    Can some help me regarding following.

    I have set a job in sql server 2008 to send reminder emails for product expiration.

    Now I want a report which will specify the list of the emails sent with the email status details like queued ,sent,delivered, failed.

    I can fetch the emails that are sent by querying the like following

    select * from sysmail_mailitems SM inner join sysmail_profile SP on SM.Profile_Id = SP.Profile_Id

    and SP.Name ='ReminderProfile'

    The problem is only getting a perfect status of email whether it is delived or failed. How I can get those status ?

    Please help.

    Thanks,

    Amol

  • August 24, 2010 at 5:20 am

    #1210930

    for others

    Database Mail keeps copies of outgoing e-mail messages and displays them in the sysmail_allitems, sysmail_sentitems, sysmail_unsentitems, sysmail_faileditems views of the msdb database. The Database Mail external program logs activity and displays the log through the Windows Application Event Log and the sysmail_event_log view in the msdb database. To check the status of an e-mail message, run a query against this view. E-mail messages have one of four possible statuses: sent, unsent, retrying, and failed.

    Thanks.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply