CREATE proc JMO_SHR_Ins (
@shr_name char(65),
@shr_key char(12),
@shr_avelp int,
@shr_avcpu int,
@shr_hcnt smallint,
@shr_erdt int,
@shr_msdt int,
@shr_deddt int,
@shr_adate int,
@shr_vdate int,
@shr_sdate int,
@shr_edate int,
@shr_ertm int,
@shr_mstm int,
@shr_dedtm int,
@shr_atime int,
@shr_vtime int,
@shr_stime int,
@shr_etime int,
@shr_relpt int,
@shr_rcput int,
@shr_qual char(5),
@shr_cc varchar(9),
@shr_ws varchar(21),
@shr_stat binary(1),
@shr_late char(1),
@shr_cmrun varchar(33),
@shr_cmhld varchar(33),
@shr_cmrls varchar(33),
@shr_cmcnc varchar(33),
@shr_cmfrc varchar(33),
@shr_avgtb int,
@shr_qname char(1)
)
as
begin
Insert into jmo_shr (
shr_name,
shr_key,
shr_avelp,
shr_avcpu,
shr_hcnt,
shr_erdt,
shr_msdt,
shr_deddt,
shr_adate,
shr_vdate,
shr_sdate,
shr_edate,
shr_ertm,
shr_mstm,
shr_dedtm,
shr_atime,
shr_vtime,
shr_stime,
shr_etime,
shr_relpt,
shr_rcput,
shr_qual,
shr_cc,
shr_ws,
shr_stat,
shr_late,
shr_cmrun,
shr_cmhld,
shr_cmrls,
shr_cmcnc,
shr_cmfrc,
shr_avgtb,
shr_qname
)
Values (
@shr_name,
@shr_key,
@shr_avelp,
@shr_avcpu,
@shr_hcnt,
@shr_erdt,
@shr_msdt,
@shr_deddt,
@shr_adate,
@shr_vdate,
@shr_sdate,
@shr_edate,
@shr_ertm,
@shr_mstm,
@shr_dedtm,
@shr_atime,
@shr_vtime,
@shr_stime,
@shr_etime,
@shr_relpt,
@shr_rcput,
@shr_qual,
@shr_cc,
@shr_ws,
@shr_stat,
@shr_late,
@shr_cmrun,
@shr_cmhld,
@shr_cmrls,
@shr_cmcnc,
@shr_cmfrc,
@shr_avgtb,
@shr_qname
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_SHR_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_SHR_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_SHR_Ins] TO [uniadmin]
GO
[dbo].[JMO_SHR_Ins]