Table - dbo.ETLExecutionLog

Properties

Property	Value
Name	ETLExecutionLog
Schema	dbo
Row Count	1
Data Size	8 KB
Index Size	8 KB
Create Date	1/28/2014 9:48 AM
Description

Columns

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
EndDtTm	smalldatetime(16, 0)	True	False	False
ETLExecutionLogId	int(10, 0)	False	False	False	(1 / 1)
ExecutionStatus	varchar(10)	False	False	False
StartDtTm	smalldatetime(16, 0)	False	False	False

Triggers

Name

Insert

Update

Delete

Instead

Indexes

Name	Clustered	Columns
PK_ETLExecutionLog	True	ETLExecutionLogId

Foreign Key Constraints

Name

Columns

Referenced Table

Referenced Columns

Checked

Check Constraints

Name	Text	Checked
chkExecutionStatus	([ExecutionStatus]='Error' OR [ExecutionStatus]='Completed' OR [ExecutionStatus]='InProcess' OR [ExecutionStatus]='Reset')	True

Parent Dependencies (objects that dbo.ETLExecutionLog depends on)

Name	Type
dbo.ETLExecutionLog_SSISConfigurations	Table
dbo.usp_ETLExecutionLog_DetailReport	StoredProcedure
dbo.usp_ETLExecutionLog_INSERT	StoredProcedure
dbo.usp_ETLExecutionLog_MostRecentExecution	StoredProcedure
dbo.usp_ETLExecutionLog_RemoveOldRecords	StoredProcedure
dbo.usp_ETLExecutionLog_ResetIncrementalLoadDates	StoredProcedure
dbo.usp_ETLExecutionLog_UPDATE	StoredProcedure

Child Dependencies (objects that depend on dbo.ETLExecutionLog)

Name	Type
dbo.ETLExecutionLog_SSISConfigurations	TABLE
dbo.usp_ETLExecutionLog_DetailReport	STOREDPROCEDURE
dbo.usp_ETLExecutionLog_INSERT	STOREDPROCEDURE
dbo.usp_ETLExecutionLog_MostRecentExecution	STOREDPROCEDURE
dbo.usp_ETLExecutionLog_RemoveOldRecords	STOREDPROCEDURE
dbo.usp_ETLExecutionLog_ResetIncrementalLoadDates	STOREDPROCEDURE
dbo.usp_ETLExecutionLog_UPDATE	STOREDPROCEDURE

Extended Properties

Object

Property

Value

Annotations

Object

Property

Value

DDL

/****** Object: Table [dbo].[ETLExecutionLog] Script Date: 03/09/2017 17:21:32 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ETLExecutionLog](
    [ETLExecutionLogId] [int] IDENTITY(1,1) NOT NULL,
    [StartDtTm] [smalldatetime] NOT NULL,
    [EndDtTm] [smalldatetime] NULL,
    [ExecutionStatus] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_ETLExecutionLog] PRIMARY KEY CLUSTERED
(
    [ETLExecutionLogId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[ETLExecutionLog]  WITH CHECK ADD  CONSTRAINT [chkExecutionStatus] CHECK  (([ExecutionStatus]='Error' OR [ExecutionStatus]='Completed' OR [ExecutionStatus]='InProcess' OR [ExecutionStatus]='Reset'))
ALTER TABLE [dbo].[ETLExecutionLog] CHECK CONSTRAINT [chkExecutionStatus]

Sample Data

EndDtTm	ETLExecutionLogId	ExecutionStatus	StartDtTm
2017-03-09T14:44:00-05:00	2	Completed	2017-03-09T11:11:00-05:00