[dbo].[ujo_chkpnt

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

	Name	Data Type	Max Length (Bytes)
$Cluster Key chkpnt_rstart_PUC: dest_machine\dest_app\as_evt_time\ubc_name\ubc_jobnumbr$	dest_machine	varchar(80)	80
$Cluster Key chkpnt_rstart_PUC: dest_machine\dest_app\as_evt_time\ubc_name\ubc_jobnumbr$	dest_app	varchar(20)	20
$Cluster Key chkpnt_rstart_PUC: dest_machine\dest_app\as_evt_time\ubc_name\ubc_jobnumbr$	as_evt_time	varchar(25)	25
$Cluster Key chkpnt_rstart_PUC: dest_machine\dest_app\as_evt_time\ubc_name\ubc_jobnumbr$	ubc_name	varchar(9)	9
$Cluster Key chkpnt_rstart_PUC: dest_machine\dest_app\as_evt_time\ubc_name\ubc_jobnumbr$	ubc_jobnumbr	varchar(15)	15
	ubc_sysid	varchar(65)	65
	ubc_date	varchar(8)	8
	ubc_time	varchar(9)	9
	ubc_procid	varchar(9)	9
	ubc_userid	varchar(33)	33
	ubc_compcod	varchar(9)	9
	ubc_jobname	varchar(65)	65
	ubc_setname	varchar(65)	65
	ubc_jobnumb	varchar(5)	5
	ubc_server	varchar(8)	8
	ubc_from_sysid	varchar(65)	65
	enefill	float	8
	ubt_cputime	varchar(9)	9
	ubt_errcod	varchar(9)	9

	Name	Columns	Unique
$Cluster Key chkpnt_rstart_PUC: dest_machine\dest_app\as_evt_time\ubc_name\ubc_jobnumbr$	chkpnt_rstart_PUC	dest_machine, dest_app, as_evt_time, ubc_name, ubc_jobnumbr

Type	Action	Owning Principal
Grant	Delete	ujoadmin
Grant	Insert	ujoadmin
Grant	Select	ujoadmin
Grant	Update	ujoadmin

SQL Script

CREATE TABLE [dbo].[ujo_chkpnt_rstart]
(
[dest_machine] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[dest_app] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[as_evt_time] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ubc_name] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ubc_jobnumbr] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ubc_sysid] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_date] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_time] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_procid] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_userid] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_compcod] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_jobname] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_setname] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_jobnumb] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_server] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubc_from_sysid] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enefill] [float] NULL,
[ubt_cputime] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ubt_errcod] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [chkpnt_rstart_PUC] ON [dbo].[ujo_chkpnt_rstart] ([dest_machine], [dest_app], [as_evt_time], [ubc_name], [ubc_jobnumbr]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_chkpnt_rstart] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_chkpnt_rstart] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_chkpnt_rstart] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_chkpnt_rstart] TO [ujoadmin]
GO