Developer Documentation Library > Interviewer - Server > Reference > Email component > SQL scheduling tables > SendEmailHistory table
 
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
SendEmailTask table
See also
SQL scheduling tables
SendEmailTask table
The SendEmailTask table provides additional information that is required for a SendEmail task.
SendEmailTask table
Id
Datatype: int
Allow nulls: no
Unique identifier for the table row.
Job
Datatype: nvarchar(200)
Allow nulls: no
The email job name that is associated with this task.
Project
Datatype: nvarchar(200)
Allow nulls: yes
The project name that is associated with the email task.
ParticipantSelectQuery
Datatype: nvarchar(MAX)
Allow nulls: no
The SQL WHERE clause that is used to select participants. This parameter can be set in the Email activity, and saved to DPM. The table value takes precedence over any DPM settings. When empty, the query from the DPM properties (for the specified project and job) is used.
ParticipantOrderBy
Datatype: nvarchar(MAX)
Allow nulls: no
The SQL ORDER BY clause that is used to select participants. This parameter can be set in the Email activity, and saved to DPM. The table value takes precedence over any DPM settings. When empty, the order from the DPM properties (for the specified project and job) is used.
BatchSize
Datatype: int
Allow nulls: no
The number of emails to send each time the task is executed (at the specified RecurrenceInterval). This parameter can be set in the Email activity, and saved to DPM. The table value takes precedence over any DPM settings. When empty, the value from the DPM properties (for the specified project and job) is used.
See also
SendEmailHistory table