Jo,

Below is the info you requested:

-- DDL for Log Table:

CREATE TABLE [dbo].[tbNewMatchBatchLog](

[NewMatchBatchLogID] [bigint] IDENTITY(1,1) NOT NULL,

[BatchType] [char](1) NOT NULL,

[NewMatchBatchID] [int] NULL,

[NewMatchBatchRunTimeID] [int] NULL,

[AgentSavedCriteriaID] [int] NULL,

[ProcedureName] [varchar](100) NOT NULL,

[Action] [varchar](100) NOT...

homebrew01,

That is an interesting suggestion that I may consider for deleting both the log records and the process records. I would like to use cascading deletes to delete the process...