CREATE TABLE [dbo].[ujo_rep_daily]
(
[hour] [int] NOT NULL,
[hour_display] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[js_running_n] [int] NULL,
[js_running_p] [float] NULL,
[js_starting_n] [int] NULL,
[js_starting_p] [float] NULL,
[js_success_n] [int] NULL,
[js_success_p] [float] NULL,
[js_failure_n] [int] NULL,
[js_failure_p] [float] NULL,
[js_terminated_n] [int] NULL,
[js_terminated_p] [float] NULL,
[js_onhold_n] [int] NULL,
[js_onhold_p] [float] NULL,
[js_onice_n] [int] NULL,
[js_onice_p] [float] NULL,
[js_inactive_n] [int] NULL,
[js_inactive_p] [float] NULL,
[js_activated_n] [int] NULL,
[js_activated_p] [float] NULL,
[js_restart_n] [int] NULL,
[js_restart_p] [float] NULL,
[jc_jrun_n] [int] NULL,
[jc_jfail_n] [int] NULL,
[jc_jforce_n] [int] NULL,
[jc_jrestart_n] [int] NULL,
[jc_quewait_n] [int] NULL,
[jc_kill_n] [int] NULL,
[jc_jedit_n] [int] NULL,
[jc_svcdesk_n] [int] NULL,
[jc_svcdesk_p] [float] NULL,
[ag_alarmres_n] [float] NULL,
[ac_alarm_n] [int] NULL,
[ac_noresponse_n] [int] NULL,
[ac_jobfail_n] [int] NULL,
[ac_stjobfail_n] [int] NULL,
[ac_maxretry_n] [int] NULL,
[ac_maxrunt_n] [int] NULL,
[ac_minrunt_n] [int] NULL,
[ac_dbroll_n] [int] NULL,
[ac_scroll_n] [int] NULL,
[ac_schshut_n] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [rep_daily_PUC] ON [dbo].[ujo_rep_daily] ([hour]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_rep_daily] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_rep_daily] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_rep_daily] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_rep_daily] TO [ujoadmin]
GO