<div>
You can use:<br />
<br />
EXECUTE msdb.dbo.sysmail_help_queu<wbr />e_sp ;<br />
GO<br />
<br />
more info on:<br />
<a href="http://technet.microsoft.com/en-us/library/ms187400.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms187400.aspx</a>
</div>


You can use:

EXECUTE msdb.dbo.sysmail_help_queue_sp ;
GO

more info on:
http://technet.microsoft.com/en-us/library/ms187400.aspx [http://technet.microsoft.com/en-us/library/ms187400.aspx]

<div>
Hope I am not missing something there,<br />
but can you specify how I can get that , in 10 emails these 9 are sent , 1 is in queue, 8 are successfully delivered and 1 is failed.<br />
<br />
I cant see any clue by using above store procedure.<br />
<br />
Thanks, please correct me if I am wrong.<br />

</div>


Hope I am not missing something there,
but can you specify how I can get that , in 10 emails these 9 are sent , 1 is in queue, 8 are successfully delivered and 1 is failed.

I cant see any clue by using above store procedure.

Thanks, please correct me if I am wrong.


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have created a scheduled job, which sends emails using msdb.dbo.sp_send_dbmail.<br />
I can successfully send emails, now I want to find whether that email is been sent sucessfully or not, and it is delived.<br />
I can get a sent_status from msdb.dbo.sysmail_mailItems<wbr /> table, but I want to have the exact delivery status.<br />
<br />
Is any way I can find this ?
</div>
</div>


Hi Experts,

I have created a scheduled job, which sends emails using msdb.dbo.sp_send_dbmail.
I can successfully send emails, now I want to find whether that email is been sent sucessfully or not, and it is delived.
I can get a sent_status from msdb.dbo.sysmail_mailItems table, but I want to have the exact delivery status.

Is any way I can find this ?

how to get Sql Database Email confirmation status

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.