[dbo].[job_history]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:19 AM Wednesday, March 07, 2007
Last Modified	11:07:19 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

11:07:19 AM Wednesday, March 07, 2007

Last Modified

11:07:19 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
id	int	4
job_id	int	4
job_name	varchar(32)	32
engine_name	varchar(32)	32
engine_type	varchar(8)	8
state	tinyint	1
starttime	datetime	8
endtime	datetime	8
datarange_starttime	datetime	8
datarange_endtime	datetime	8
records_processed	int	4
text	varchar(1024)	1024

Name

Data Type

Max Length (Bytes)

Allow Nulls

int

job_id

int

job_name

varchar(32)

engine_name

varchar(32)

engine_type

varchar(8)

state

tinyint

starttime

datetime

endtime

datetime

datarange_starttime

datetime

datarange_endtime

datetime

records_processed

int

text

varchar(1024)

1024

SQL Script

CREATE TABLE [dbo].[job_history]
(
[id] [int] NULL,
[job_id] [int] NULL,
[job_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[engine_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[engine_type] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[state] [tinyint] NULL,
[starttime] [datetime] NULL,
[endtime] [datetime] NULL,
[datarange_starttime] [datetime] NULL,
[datarange_endtime] [datetime] NULL,
[records_processed] [int] NULL,
[text] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO