CREATE TABLE [dbo].[ujo_job_runs]
(
[joid] [int] NULL,
[run_num] [int] NULL,
[ntry] [int] NULL,
[startime] [int] NULL,
[endtime] [int] NULL,
[status] [int] NULL,
[exit_code] [int] NULL,
[runtime] [int] NULL,
[evt_num] [int] NULL,
[machine] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[std_out_file] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[std_err_file] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[svcdesk_status] [int] NULL,
[svcdesk_handle] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ujo_job_runs_idx_01] ON [dbo].[ujo_job_runs] ([evt_num]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [job_runs_PUC] ON [dbo].[ujo_job_runs] ([joid], [run_num], [ntry], [machine]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ujo_job_runs_idx_02] ON [dbo].[ujo_job_runs] ([machine]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_job_runs] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_job_runs] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_job_runs] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_job_runs] TO [ujoadmin]
GO