CREATE TABLE [dbo].[ujo_job_status]
(
[joid] [int] NOT NULL,
[status] [smallint] NOT NULL,
[status_time] [int] NOT NULL,
[run_num] [int] NULL,
[last_start] [int] NULL,
[last_end] [int] NULL,
[next_start] [int] NULL,
[run_window_end] [int] NULL,
[ntry] [int] NULL,
[appl_ntry] [int] NULL,
[time_ok] [smallint] NULL,
[exit_code] [int] NULL,
[run_machine] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[que_name] [varchar] (62) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[run_priority] [int] NULL,
[next_priority] [int] NULL,
[pid] [int] NULL,
[jc_pid] [int] NULL,
[last_heartbeat] [int] NULL,
[evt_num] [int] NULL,
[over_num] [int] NULL,
[mvsflag] [int] NULL,
[mvsnode] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobset] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mvsjobname] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[qual] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jno] [int] NULL,
[entryno] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mvsautoserv] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [job_status_PUC] ON [dbo].[ujo_job_status] ([joid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_job_status] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_job_status] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_job_status] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_job_status] TO [ujoadmin]
GO