SendEmailHistory table
The SendEmailHistory table provides a real-time view and batch history that is sent by the SendEmail tasks and by using the Send Now link. Active batches have a record in the SendEmailHistory table.
Columns
Id
Datatype: int
Allow nulls: yes
Unique identifier for the table row.
ScheduledTaskId
Datatype: int
Allow nulls: yes
A foreign key for the Id column in the ScheduleTask table. The key defines the schedule that caused the task to be executed. The value is NULL when emails are sent via the Send Now option.
Project
Datatype: nvarchar(200)
Allow nulls: no
Project name for which emails are sent.
Job
Datatype: nvarchar(200)
Allow nulls: no
The job name for which emails are sent.
ProcessingServer
Datatype: nvarchar(200)
Allow nulls: yes
Holds the name of the processing server that initiated the task. Not reset to Null when a task is not active.
BatchNumber
Datatype: int
Allow nulls: no
Initialized from CurrentBatch when the batch is scheduled;0 when it is a Send now job.
BatchStatus
Datatype: int
Allow nulls: no
The batch status:
▪Active: Task is active / processing.
▪Stopped: Task was stopped before completion.
▪Succeeded: The batch succeeded. This does not mean that all emails were sent successfully; it means that all emails were attempted.
▪Failed: A batch fails when the email server is unavailable or when a error occurs that causes the script to prematurely stop processing the batch.
▪Abandoned: A batch is marked as abandoned when it is cleaned up because it appears to be “stuck in active”.
ScheduledBatchStartTime
Datatype: datetime
Allow nulls: yes
Copied from the original NextDueTime when a batch is completed (UTC).
BatchStartTime
Datatype: datetime
Allow nulls: no
The batch start time (UTC).
BatchEndTime
Datatype: datetime
Allow nulls: yes
The batch end time (UTC).
SuccessfulEmailCount
Datatype: int
Allow nulls: no
Number of successful emails that were sent in this batch.
FailedEmailCount
Datatype: int
Allow nulls: no
Number of failed emails that were sent in this batch.
ParticipantSelectQuery
Datatype: nvarchar(MAX)
Allow nulls: no
The WHERE clause that was used to select the participants for this batch. This can be the WHERE clause that was specified for the job in DPM, the value from the SendEmailTask table, or a value that was specified by the sending script.
ParticipantOrderBy
Datatype: nvarchar(MAX)
Allow nulls: no
The ORDER BY clause that was used to order the participants for this batch. This can be the ORDER BY clause that was specified for the job in DPM, the value from the SendEmailTask table, or a value that was specified by the sending script.
See
See also