[dbo].[arg_job

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	7
Created	12:30:44 PM Sunday, December 05, 2010
Last Modified	10:34:22 PM Thursday, February 10, 2011

	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	swcmadmin
Grant	Insert	swcmadmin
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]
GO