CREATE TABLE [dbo].[jv_job]
(
[jobid] [int] NOT NULL,
[instancename] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[as_alarmiffail] [smallint] NULL,
[as_autodelete] [smallint] NULL,
[jobname] [varchar] (84) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[as_autohold] [smallint] NULL,
[regionid] [int] NULL,
[sched_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_condition] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[job_variable] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[kill_signal] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobowner] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_boxterminator] [smallint] NULL,
[boxjobid] [int] NULL,
[jobtype] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[as_daysofweek] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobleft] [int] NULL,
[as_excludecalendar] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobright] [int] NULL,
[jobtop] [int] NULL,
[as_jobload] [smallint] NULL,
[as_jobterminator] [smallint] NULL,
[as_description] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobbottom] [int] NULL,
[as_dateconditions] [smallint] NULL,
[as_maxrunalarm] [smallint] NULL,
[as_minrunalarm] [smallint] NULL,
[as_nretrys] [smallint] NULL,
[as_startmins] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_starttimes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_permission] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_priority] [smallint] NULL,
[as_runcalendar] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[checkoutsid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[checkoutname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lastsynctime] [int] NULL,
[lastmodtime] [int] NULL,
[cloneid] [int] NULL,
[as_termruntime] [smallint] NULL,
[boxname] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_timezone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[templatejobid] [int] NULL,
[bagname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[job_mode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[application] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_group] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[max_concur_runs] [int] NULL,
[save_cycles] [int] NULL,
[restart_wait] [int] NULL,
[run_as_ptid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[not_after_start_time] [int] NULL,
[pre_load_mins] [int] NULL,
[alarm_start_late] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[avg_duration] [int] NULL,
[operator_ok] [int] NULL,
[app_status_var] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_runwindow] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_jv_job] ON [dbo].[jv_job] ([jobid]) ON [PRIMARY]
GO