[dbo].[mitjas

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

Name	Data Type	Max Length (Bytes)
joid	decimal(15,0)	9
groupid	decimal(15,0)	9
username	varchar(50)	50
userrole	varchar(125)	125
node	varchar(60)	60
deployed	decimal(15,0)	9
next_start	decimal(15,0)	9
command	varchar(255)	255
commandb	varchar(255)	255
runcount	int	4
timezone	int	4
wstimezone	varchar(12)	12
retryinterval	int	4
retrycount	int	4
n_retrys	int	4
recurfailcount	int	4
notificationemail	varchar(185)	185
completionscript	varchar(185)	185
failedscript	varchar(185)	185
productcode	varchar(8)	8
productversion	varchar(8)	8
description	varchar(128)	128
type	varchar(30)	30
instance	varchar(60)	60
owner	varchar(50)	50
cred_value	varchar(60)	60
connectstring	varchar(60)	60
jobowner	varchar(50)	50
accessmode	char(1)	1
can_be_resumed	smallint	2
resume_requested	smallint	2
run_to_resume	int	4
object	varchar(60)	60
runstate	smallint	2
calendarid	char(30)	30
recurinterval	int	4
recurincrement	int	4
everyweekday	smallint	2
days_of_week	char(7)	7
dayofmonthflags	char(31)	31
lastdayofmonth	smallint	2
yearmonth	smallint	2
timeofdayhour	smallint	2
timeofdayminute	smallint	2
start_times	char(60)	60
cookies	int	4
n_preemptretries	int	4

	Name	Columns	Unique
	XPKmitjas_job	joid

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

SQL Script

CREATE TABLE [dbo].[mitjas_job]
(
[joid] [decimal] (15, 0) NOT NULL,
[groupid] [decimal] (15, 0) NULL,
[username] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[userrole] [varchar] (125) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[node] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[deployed] [decimal] (15, 0) NULL,
[next_start] [decimal] (15, 0) NULL,
[command] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[commandb] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[runcount] [int] NULL,
[timezone] [int] NULL,
[wstimezone] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[retryinterval] [int] NULL,
[retrycount] [int] NULL,
[n_retrys] [int] NULL,
[recurfailcount] [int] NULL,
[notificationemail] [varchar] (185) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[completionscript] [varchar] (185) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[failedscript] [varchar] (185) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[productcode] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[productversion] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[instance] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cred_value] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[connectstring] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobowner] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[accessmode] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[can_be_resumed] [smallint] NULL,
[resume_requested] [smallint] NULL,
[run_to_resume] [int] NULL,
[object] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[runstate] [smallint] NULL,
[calendarid] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[recurinterval] [int] NULL,
[recurincrement] [int] NULL,
[everyweekday] [smallint] NULL,
[days_of_week] [char] (7) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dayofmonthflags] [char] (31) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lastdayofmonth] [smallint] NULL,
[yearmonth] [smallint] NULL,
[timeofdayhour] [smallint] NULL,
[timeofdayminute] [smallint] NULL,
[start_times] [char] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cookies] [int] NULL,
[n_preemptretries] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[mitjas_job] ADD CONSTRAINT [XPKmitjas_job] PRIMARY KEY CLUSTERED ([joid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[mitjas_job] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[mitjas_job] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[mitjas_job] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[mitjas_job] TO [udmadmin_group]
GO