Tables [dbo].[arg_job]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count507
Created12:30:43 PM Sunday, December 05, 2010
Last Modified10:34:22 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_arg_job: job_idjob_idint4
No
definitionimagemax
Yes
ownernvarchar(50)100
Yes
object_idnvarchar(50)100
Yes
object_typeint4
No
actionint4
Yes
statusnvarchar(255)510
Yes
status_messagenvarchar(2000)4000
Yes
server_namenvarchar(255)510
Yes
job_typeint4
Yes
process_idnvarchar(255)510
Yes
Indexes arg_job_idx_01: categorycategorynvarchar(255)510
Yes
creation_usernvarchar(255)510
Yes
creation_dateint4
Yes
last_update_usernvarchar(255)510
Yes
last_update_dateint4
Yes
version_numberint4
No
('0')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_arg_job: job_idPK_arg_jobjob_id
Yes
arg_job_idx_01category
Permissions
TypeActionOwning Principal
GrantDeleteswcmadmin
GrantInsertswcmadmin
GrantSelectswcmadmin
GrantUpdateswcmadmin
SQL Script
CREATE TABLE [dbo].[arg_job]
(
[job_id] [int] NOT NULL,
[definition] [image] NULL,
[owner] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[object_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[object_type] [int] NOT NULL,
[action] [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,
[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,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NOT NULL CONSTRAINT [DF_arg_job_version_number] DEFAULT ('0')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_job] ADD CONSTRAINT [PK_arg_job] PRIMARY KEY CLUSTERED ([job_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [arg_job_idx_01] ON [dbo].[arg_job] ([category]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[arg_job] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_job] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_job] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_job] TO [swcmadmin]
GO
Uses
Used By