Table of Contents

Class DatabaseMailSchema.SentItem

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sysmail_sentitems (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance

Contains one row for each message sent by Database Mail. Use sysmail_sentitems when you want to see which messages were successfully sent.
To see all messages processed by Database Mail, use sysmail_allitems (Transact-SQL). To see only messages with the failed status, use sysmail_faileditems (Transact-SQL). To see only unsent or retrying messages, use sysmail_unsentitems (Transact-SQL). To see e-mail attachments, use sysmail_mailattachments (Transact-SQL).


See dbo.sysmail_sentitems.

[Table(Database = "msdb", Schema = "dbo", Name = "sysmail_sentitems", IsView = true)]
public class DatabaseMailSchema.SentItem
Inheritance
DatabaseMailSchema.SentItem
Extension Methods

Properties

AppendQueryError

The append_query_error parameter of the message. 0 indicates that Database Mail should not send the e-mail message if there is an error in the query.

[Column("append_query_error")]
[NotNull]
public bool AppendQueryError { get; set; }

Property Value

bool

AttachQueryResultAsFile

When the value is 0, the query results were included in the body of the e-mail message, after the contents of the body. When the value is 1, the results were returned as an attachment.

[Column("attach_query_result_as_file")]
[NotNull]
public bool AttachQueryResultAsFile { get; set; }

Property Value

bool

AttachmentEncoding

The type of mail attachment.

[Column("attachment_encoding")]
[NotNull]
public string AttachmentEncoding { get; set; }

Property Value

string

BlindCopyRecipients

The e-mail addresses of those who receive copies of the message but whose names do not appear in the message header.

[Column("blind_copy_recipients")]
[NotNull]
public string BlindCopyRecipients { get; set; }

Property Value

string

Body

The body of the message.

[Column("body")]
[NotNull]
public string Body { get; set; }

Property Value

string

BodyFormat

The body format of the message. The possible values are TEXT and HTML.

[Column("body_format")]
[NotNull]
public string BodyFormat { get; set; }

Property Value

string

CopyRecipients

The e-mail addresses of those who receive copies of the message.

[Column("copy_recipients")]
[NotNull]
public string CopyRecipients { get; set; }

Property Value

string

ExcludeQueryOutput

The exclude_query_output parameter of the message. For more information, see sp_send_dbmail (Transact-SQL).

[Column("exclude_query_output")]
[NotNull]
public bool ExcludeQueryOutput { get; set; }

Property Value

bool

ExecuteQueryDatabase

The database context within which the mail program executed the query.

[Column("execute_query_database")]
[NotNull]
public string ExecuteQueryDatabase { get; set; }

Property Value

string

FileAttachments

A semicolon-delimited list of file names attached to the e-mail message.

[Column("file_attachments")]
[NotNull]
public string FileAttachments { get; set; }

Property Value

string

Importance

The importance parameter of the message.

[Column("importance")]
[NotNull]
public string Importance { get; set; }

Property Value

string

LastModDate

The date and time of the last modification of the row.

[Column("last_mod_date")]
[NotNull]
public DateTime LastModDate { get; set; }

Property Value

DateTime

LastModUser

The user who last modified the row.

[Column("last_mod_user")]
[NotNull]
public string LastModUser { get; set; }

Property Value

string

MailItemID

Identifier of the mail item in the mail queue.

[Column("mailitem_id")]
[NotNull]
public int MailItemID { get; set; }

Property Value

int

ProfileID

The identifier of the profile used to send the message.

[Column("profile_id")]
[NotNull]
public int ProfileID { get; set; }

Property Value

int

Query

The query executed by the mail program.

[Column("query")]
[NotNull]
public string Query { get; set; }

Property Value

string

QueryResultHeader

When the value is 1, query results contained column headers. When the value is 0, query results did not include column headers.

[Column("query_result_header")]
[NotNull]
public bool QueryResultHeader { get; set; }

Property Value

bool

QueryResultSeparator

The character used to separate columns in the query output.

[Column("query_result_separator")]
[NotNull]
public string QueryResultSeparator { get; set; }

Property Value

string

QueryResultWidth

The query_result_width parameter of the message.

[Column("query_result_width")]
[NotNull]
public int QueryResultWidth { get; set; }

Property Value

int

Recipients

The e-mail addresses of the message recipients.

[Column("recipients")]
[NotNull]
public string Recipients { get; set; }

Property Value

string

SendRequestDate

The date and time the message was placed on the mail queue.

[Column("send_request_date")]
[NotNull]
public DateTime SendRequestDate { get; set; }

Property Value

DateTime

SendRequestUser

The user who sent the message. This is the user context of the database mail procedure, not the From: field of the message.

[Column("send_request_user")]
[NotNull]
public string SendRequestUser { get; set; }

Property Value

string

Sensitivity

The sensitivity parameter of the message.

[Column("sensitivity")]
[NotNull]
public string Sensitivity { get; set; }

Property Value

string

SentAccountID

The identifier of the Database Mail account used to send the message.

[Column("sent_account_id")]
[NotNull]
public int SentAccountID { get; set; }

Property Value

int

SentDate

The date and time that the message was sent.

[Column("sent_date")]
[NotNull]
public DateTime SentDate { get; set; }

Property Value

DateTime

SentStatus

The status of the mail. Always sent for this view.

[Column("sent_status")]
[NotNull]
public string SentStatus { get; set; }

Property Value

string

Subject

The subject line of the message.

[Column("subject")]
[NotNull]
public string Subject { get; set; }

Property Value

string