[dbo].[arg_job

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	4
Created	2:23:37 PM Friday, March 21, 2008
Last Modified	2:23:37 PM Friday, March 21, 2008

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_arg_job_task: job_id\job_task_id$	job_id	int	4
	object_id	nvarchar(50)	100
	object_type	int	4
	status	nvarchar(255)	510
	status_message	nvarchar(2000)	4000
	creation_date	int	4
	creation_user	nvarchar(255)	510
	last_update_date	int	4
	last_update_user	nvarchar(255)	510
	version_number	int	4	((0))
$Cluster Primary Key PK_arg_job_task: job_id\job_task_id$	job_task_id	int	4
	server_name	nvarchar(255)	510
	job_type	int	4
	process_id	nvarchar(255)	510
	category	nvarchar(255)	510

	Name	Columns	Unique
$Cluster Primary Key PK_arg_job_task: job_id\job_task_id$	PK_arg_job_task	job_id, job_task_id

Name	Columns
arg_job_task_fk01	job_id->[dbo].[arg_job].[job_id]

Type	Action	Owning Principal
Grant	Delete	uapmreporting
Grant	Insert	uapmreporting
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	uapmreporting_group
Grant	Insert	uapmreporting_group
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Update	uapmreporting_group
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Update	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin

SQL Script

CREATE TABLE [dbo].[arg_job_task]
(
[job_id] [int] NOT NULL,
[object_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[object_type] [int] NULL,
[status] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status_message] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[version_number] [int] NOT NULL CONSTRAINT [DF_arg_job_task_version_number] DEFAULT ((0)),
[job_task_id] [int] NOT NULL,
[server_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[job_type] [int] NULL,
[process_id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[category] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_job_task] ADD CONSTRAINT [PK_arg_job_task] PRIMARY KEY CLUSTERED ([job_id], [job_task_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_job_task] ADD CONSTRAINT [arg_job_task_fk01] FOREIGN KEY ([job_id]) REFERENCES [dbo].[arg_job] ([job_id])
GO
GRANT SELECT ON  [dbo].[arg_job_task] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_job_task] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_job_task] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_job_task] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_job_task] TO [uapmadmin]
GRANT INSERT ON  [dbo].[arg_job_task] TO [uapmadmin]
GRANT DELETE ON  [dbo].[arg_job_task] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[arg_job_task] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_job_task] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[arg_job_task] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[arg_job_task] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[arg_job_task] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_job_task] TO [uapmbatch]
GRANT INSERT ON  [dbo].[arg_job_task] TO [uapmbatch]
GRANT DELETE ON  [dbo].[arg_job_task] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[arg_job_task] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_job_task] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[arg_job_task] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[arg_job_task] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[arg_job_task] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_job_task] TO [uapmreporting]
GRANT INSERT ON  [dbo].[arg_job_task] TO [uapmreporting]
GRANT DELETE ON  [dbo].[arg_job_task] TO [uapmreporting]
GRANT UPDATE ON  [dbo].[arg_job_task] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_job_task] TO [uapmreporting_group]
GRANT INSERT ON  [dbo].[arg_job_task] TO [uapmreporting_group]
GRANT DELETE ON  [dbo].[arg_job_task] TO [uapmreporting_group]
GRANT UPDATE ON  [dbo].[arg_job_task] TO [uapmreporting_group]
GO