SendEmailHistory table
The SendEmailHistory table provides a real-time view and batch history that is sent by theSendEmail tasks and by using the Send Now link. Active batches have a record in the SendEmailHistory table.
Columns
Id
Unique identifier for the table row.
Datatype: int
Allow nulls: yes
ScheduledTaskId
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 by using the Send Now option.
Datatype: int
Allow nulls: yes
Project
Project name for which emails are sent.
Datatype: nvarchar(200)
Allow nulls: no
Job
The job name for which emails are sent.
Datatype: nvarchar(200)
Allow nulls: no
ProcessingServer
Holds the name of the processing server that initiated the task. Not reset toNull when a task is not active.
Datatype: nvarchar(200)
Allow nulls: yes
BatchNumber
Initialized from CurrentBatch when the batch is scheduled;0 when it is a Send now job.
Datatype: int
Allow nulls: no
BatchStatus
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”.
Datatype: int
Allow nulls: no
ScheduledBatchStartTime
Copied from the original NextDueTime when a batch is completed (UTC).
Datatype: datetime
Allow nulls: yes
BatchStartTime
The batch start time (UTC).
Datatype: datetime
Allow nulls: no
BatchEndTime
The batch end time (UTC).
Datatype: datetime
Allow nulls: yes
SuccessfulEmailCount
Number of successful emails that were sent in this batch.
Datatype: int
Allow nulls: no
FailedEmailCount
Number of failed emails that were sent in this batch.
Datatype: int
Allow nulls: no
ParticipantSelectQuery
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.
Datatype: nvarchar(MAX)
Allow nulls: no
ParticipantOrderBy
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.
Datatype: nvarchar(MAX)
Allow nulls: no
See also