[dbo].[jv_command

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:09:39 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
jobid	int	4
as_chkfiles	varchar(255)	255
as_command	varchar(1)	1
as_heartbeatinterval	smallint	2
as_maxexitsuccess	varchar(255)	255
as_machine	varchar(255)	255
as_profile	varchar(255)	255
as_stderrfile	varchar(255)	255
as_stdinfile	varchar(255)	255
as_stdoutfile	varchar(255)	255
target_mode	varchar(32)	32
cloneid	int	4
templatejobid	int	4

Name	Columns	Unique
baseidx_jv_command_job	jobid

SQL Script

CREATE TABLE [dbo].[jv_command_job]
(
[jobid] [int] NOT NULL,
[as_chkfiles] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_command] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_heartbeatinterval] [smallint] NULL,
[as_maxexitsuccess] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_machine] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_profile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_stderrfile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_stdinfile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_stdoutfile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[target_mode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cloneid] [int] NULL,
[templatejobid] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_jv_command_job] ON [dbo].[jv_command_job] ([jobid]) ON [PRIMARY]
GO