[cohesion].[QLJOB

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:18:10 AM Friday, April 20, 2007
Last Modified	11:18:10 AM Friday, April 20, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:18:10 AM Friday, April 20, 2007

Last Modified

11:18:10 AM Friday, April 20, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__QLJOB_DETAILS__367C1819: JOB_NAME\JOB_GROUP$	JOB_NAME	varchar(90)	90
$Cluster Primary Key PK__QLJOB_DETAILS__367C1819: JOB_NAME\JOB_GROUP$	JOB_GROUP	varchar(90)	90
	JOB_CLASS_NAME	varchar(255)	255
	IS_DURABLE	varchar(1)	1
	IS_STATEFUL	varchar(1)	1
	REQUESTS_RECOVERY	varchar(1)	1
	JOB_DATA	image	max
	DESCRIPTION	varchar(255)	255
	IS_VOLATILE	varchar(1)	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__QLJOB_DETAILS__367C1819: JOB_NAME\JOB_GROUP$

JOB_NAME

varchar(90)

$Cluster Primary Key PK__QLJOB_DETAILS__367C1819: JOB_NAME\JOB_GROUP$

JOB_GROUP

varchar(90)

JOB_CLASS_NAME

varchar(255)

255

IS_DURABLE

varchar(1)

IS_STATEFUL

varchar(1)

REQUESTS_RECOVERY

varchar(1)

JOB_DATA

image

max

DESCRIPTION

varchar(255)

255

IS_VOLATILE

varchar(1)

	Name	Columns	Unique
$Cluster Primary Key PK__QLJOB_DETAILS__367C1819: JOB_NAME\JOB_GROUP$	PK__QLJOB_DETAILS__367C1819	JOB_NAME, JOB_GROUP
	XIE1QLJOB_DETAILS	REQUESTS_RECOVERY

Name

Columns

Unique

$Cluster Primary Key PK__QLJOB_DETAILS__367C1819: JOB_NAME\JOB_GROUP$

PK__QLJOB_DETAILS__367C1819

JOB_NAME, JOB_GROUP

XIE1QLJOB_DETAILS

REQUESTS_RECOVERY

SQL Script

CREATE TABLE [cohesion].[QLJOB_DETAILS]
(
[JOB_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[JOB_GROUP] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[JOB_CLASS_NAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IS_DURABLE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IS_STATEFUL] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REQUESTS_RECOVERY] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[JOB_DATA] [image] NULL,
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IS_VOLATILE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [cohesion].[QLJOB_DETAILS] ADD CONSTRAINT [PK__QLJOB_DETAILS__367C1819] PRIMARY KEY CLUSTERED ([JOB_NAME], [JOB_GROUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1QLJOB_DETAILS] ON [cohesion].[QLJOB_DETAILS] ([REQUESTS_RECOVERY]) ON [PRIMARY]
GO