[dbo].[ujo_overjob]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:40 AM Wednesday, March 07, 2007
Last Modified	11:10:03 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Key overjob_PUC: joid\over_num$	joid	int	4
	machine	varchar(80)	80
	n_retrys	int	4
	auto_hold	smallint	2
	command	varchar(255)	255
	date_conditions	smallint	2
	days_of_week	varchar(80)	80
	run_calendar	varchar(30)	30
	exclude_calendar	varchar(30)	30
	start_times	varchar(255)	255
	start_mins	varchar(255)	255
	run_window	varchar(20)	20
	term_run_time	int	4
	profile	varchar(255)	255
	std_in_file	varchar(255)	255
	std_out_file	varchar(255)	255
	std_err_file	varchar(255)	255
	watch_file	varchar(255)	255
	watch_file_min_size	int	4
	watch_interval	int	4
	min_run_alarm	int	4
	max_run_alarm	int	4
$Cluster Key overjob_PUC: joid\over_num$	over_num	int	4
	entity	varchar(80)	80
	run_num	int	4
	setup_time	int	4
	start_time	int	4

	Name	Columns	Unique
$Cluster Key overjob_PUC: joid\over_num$	overjob_PUC	joid, over_num

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

SQL Script

CREATE TABLE [dbo].[ujo_overjob]
(
[joid] [int] NOT NULL,
[machine] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[n_retrys] [int] NULL,
[auto_hold] [smallint] NULL,
[command] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[date_conditions] [smallint] NULL,
[days_of_week] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[run_calendar] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[exclude_calendar] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[start_times] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[start_mins] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[run_window] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[term_run_time] [int] NULL,
[profile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[std_in_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[std_out_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[std_err_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[watch_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[watch_file_min_size] [int] NULL,
[watch_interval] [int] NULL,
[min_run_alarm] [int] NULL,
[max_run_alarm] [int] NULL,
[over_num] [int] NOT NULL,
[entity] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[run_num] [int] NULL,
[setup_time] [int] NULL,
[start_time] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [overjob_PUC] ON [dbo].[ujo_overjob] ([joid], [over_num]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_overjob] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_overjob] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_overjob] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_overjob] TO [ujoadmin]
GO