EMAILPROCESSTRACKING

Table tracks number of currently running email processes

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
PROCESSTYPE	nvarchar(50)		Default = ''	The type of email process
THREADNAME	nvarchar(50)		Default = ''	Name of the thread
ISACTIVE	bit		Default = 0	Indicates if thread is currently processing
THREADSTARTDATE	datetime	yes		Indicates when the thread last started processing
THREADSTOPDATE	datetime	yes		Indicates when the thread last stopped processing
CHUNKSPROCESSED	int		Default = 0	Indicates the number of jobs the thread processed

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_EMAILPROCESSTRACKING	ID	yes	yes	yes