Class DatabaseMailSchema.EventLog

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sysmail_event_log (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains one row for each Windows or SQL Server message returned by the Database Mail system. (Message in this context refers to a message such as an error message, not an e-mail message.) Configure the Logging Level parameter by using the Configure System Parameters dialog box of the Database Mail Configuration Wizard, or the sysmail_configure_sp stored procedure, to determine which messages are returned.

See dbo.sysmail_event_log.

[Table(Database = "msdb", Schema = "dbo", Name = "sysmail_event_log", IsView = true)]
public class DatabaseMailSchema.EventLog

Inheritance

object

DatabaseMailSchema.EventLog

Extension Methods

Map.DeepCopy<T>(T)

Properties

AccountID

The account_id of the account related to the event. NULL if the message is not related to a specific account.

[Column("account_id")]
[NotNull]
public int AccountID { get; set; }

Property Value

int

Description

The text of the message being recorded.

[Column("description")]
[NotNull]
public string Description { get; set; }

Property Value

string

EventType

The type of notice inserted in the log. Possible values are errors, warnings, informational messages, success messages, and additional internal messages.

[Column("event_type")]
[NotNull]
public string EventType { 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. For e-mails, this is the user who sent the mail. For messages generated by the Database Mail external program, this is the user context of the program.

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

Property Value

string

LogDate

The date and time the log entry is made.

[Column("log_date")]
[NotNull]
public DateTime LogDate { get; set; }

Property Value

DateTime

LogID

Identifier of items in the log.

[Column("Log_id")]
[NotNull]
public int LogID { get; set; }

Property Value

int

MailItemID

Identifier of the mail item in the mail queue. NULL if the message is not related to a specific e-mail item.

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

Property Value

int

ProcessID

The process id of the Database Mail external program. This typically changes each time the Database Mail external program starts.

[Column("process_id")]
[NotNull]
public int ProcessID { get; set; }

Property Value

int