[dbo].[ujo

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)
$Indexes ujo_job_idx_01: job_name\joid$	joid	int	4
$Indexes ujo_job_idx_01: job_name\joid$	job_name	varchar(64)	64
	job_type	char(1)	1
	box_joid	int	4
	owner	varchar(80)	80
	permission	varchar(30)	30
	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
	description	varchar(255)	255
	term_run_time	int	4
	box_terminator	smallint	2
	job_terminator	smallint	2
	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
	alarm_if_fail	smallint	2
	chk_files	varchar(255)	255
	free_procs	int	4
	profile	varchar(255)	255
	heartbeat_interval	int	4
	job_load	int	4
	priority	int	4
	auto_delete	int	4
	numero	int	4
	max_exit_success	int	4
	box_success	varchar(255)	255
	box_failure	varchar(255)	255
	send_notification	char(1)	1
	service_desk	int	4

	Name	Columns	Unique
	job_PUC	joid
	ujo_job_idx_01	job_name, joid
	ujo_job_idx_02	box_joid

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

SQL Script

CREATE TABLE [dbo].[ujo_job]
(
[joid] [int] NOT NULL,
[job_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[job_type] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[box_joid] [int] NULL,
[owner] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[permission] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS 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,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[term_run_time] [int] NULL,
[box_terminator] [smallint] NULL,
[job_terminator] [smallint] 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,
[alarm_if_fail] [smallint] NULL,
[chk_files] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[free_procs] [int] NULL,
[profile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[heartbeat_interval] [int] NULL,
[job_load] [int] NULL,
[priority] [int] NULL,
[auto_delete] [int] NULL,
[numero] [int] NULL,
[max_exit_success] [int] NULL,
[box_success] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[box_failure] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[send_notification] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[service_desk] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ujo_job_idx_02] ON [dbo].[ujo_job] ([box_joid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [ujo_job_idx_01] ON [dbo].[ujo_job] ([job_name], [joid]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [job_PUC] ON [dbo].[ujo_job] ([joid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_job] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_job] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_job] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_job] TO [ujoadmin]
GO