KSOA之历史操作日志gnlog

方法1：修改tomcat==>webapps\ROOT\WEB-INF\classes\shikong.properties文件中的dblog.reservedays=6000，应该是保留日志天数

方法2：作业转his

方法3：gnlog上面写触发器，存到gnlog_fc

　　

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[tr_gnlog] ON [dbo].[gnlog]
FOR INSERT
AS
insert into gnlog_fc(rq,ontime,caozy,gnbh,plh,jiqmch,mkbh,duifbsh)
select a.rq,a.ontime,a.caozy,a.gnbh,a.plh,a.jiqmch,a.mkbh,a.duifbsh from inserted a