CREATE TABLE xxx.xxx (
	ID int NOT NULL IDENTITY(1,1),
	JobID int NOT NULL,
	Status nvarchar(255) NULL,
	ErrorMessage nvarchar(MAX) NULL,
	AffectedRows int NULL,
	JobStart datetime NULL,
	JobEnd datetime NULL,
	messageKey nvarchar(100) NULL,
	jobEvent nvarchar(MAX) NULL,
	message nvarchar(MAX) NULL,
	CONSTRAINT PK_JOBEXECUTIONHISTORY PRIMARY KEY (ID)
);