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 ?
View Complete Post