CREATE proc JMO_JHR_Ins (
@jhr_jschd char(65),
@jhr_name char(65),
@jhr_jno char(5),
@jhr_key char(12),
@jhr_ws varchar(21),
@jhr_avcpu int,
@jhr_hcnt smallint,
@jhr_erdt int,
@jhr_msdt int,
@jhr_deddt int,
@jhr_adate int,
@jhr_vdate int,
@jhr_sdate int,
@jhr_edate int,
@jhr_ertm int,
@jhr_mstm int,
@jhr_dedtm int,
@jhr_atime int,
@jhr_vtime int,
@jhr_stime int,
@jhr_etime int,
@jhr_relpt int,
@jhr_rcput int,
@jhr_code int,
@jhr_qual char(4),
@jhr_stat binary(1),
@jhr_late char(1),
@jhr_cmrun varchar(33),
@jhr_cmhld varchar(33),
@jhr_cmrls varchar(33),
@jhr_cmcnc varchar(33),
@jhr_cmfrc varchar(33),
@jhr_cmstr varchar(33),
@jhr_cmcmp varchar(33),
@jhr_pid int,
@jhr_uxjno int,
@jhr_sysid varchar(65),
@jhr_avelp int,
@jhr_qname char(1)
)
as
begin
Insert into jmo_jhr (
jhr_jschd,
jhr_name,
jhr_jno,
jhr_key,
jhr_ws,
jhr_avcpu,
jhr_hcnt,
jhr_erdt,
jhr_msdt,
jhr_deddt,
jhr_adate,
jhr_vdate,
jhr_sdate,
jhr_edate,
jhr_ertm,
jhr_mstm,
jhr_dedtm,
jhr_atime,
jhr_vtime,
jhr_stime,
jhr_etime,
jhr_relpt,
jhr_rcput,
jhr_code,
jhr_qual,
jhr_stat,
jhr_late,
jhr_cmrun,
jhr_cmhld,
jhr_cmrls,
jhr_cmcnc,
jhr_cmfrc,
jhr_cmstr,
jhr_cmcmp,
jhr_pid,
jhr_uxjno,
jhr_sysid,
jhr_avelp,
jhr_qname
)
Values (
@jhr_jschd,
@jhr_name,
@jhr_jno,
@jhr_key,
@jhr_ws,
@jhr_avcpu,
@jhr_hcnt,
@jhr_erdt,
@jhr_msdt,
@jhr_deddt,
@jhr_adate,
@jhr_vdate,
@jhr_sdate,
@jhr_edate,
@jhr_ertm,
@jhr_mstm,
@jhr_dedtm,
@jhr_atime,
@jhr_vtime,
@jhr_stime,
@jhr_etime,
@jhr_relpt,
@jhr_rcput,
@jhr_code,
@jhr_qual,
@jhr_stat,
@jhr_late,
@jhr_cmrun,
@jhr_cmhld,
@jhr_cmrls,
@jhr_cmcnc,
@jhr_cmfrc,
@jhr_cmstr,
@jhr_cmcmp,
@jhr_pid,
@jhr_uxjno,
@jhr_sysid,
@jhr_avelp,
@jhr_qname
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_JHR_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_JHR_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_JHR_Ins] TO [uniadmin]
GO
[dbo].[JMO_JHR_Ins]