后台事务异常查询

--查询后台事务隔离边界

select t.fid,t.FisolationBoundary from t_job_trigger t 

left join t_job_def d on t.fjobDefId=d.fjobDefId

 where d.ftitle='更新批次平均投苗日龄'

--172.16.2.242

--查询服务器隔离边界(运行服务端脚本)

com.kingdee.bos.service.job.core.Configuration.defaultTriggerIsolationBoundary()

--192.168.0.228

--查询后台事务运行实例表

select * from t_job_service

--查询IP不对的数据

select t.fid,t.FisolationBoundary,d.ftitle from t_job_trigger t 

left join t_job_def d on t.fjobDefId=d.fjobDefId

 where t.FisolationBoundary != '192.168.0.228'

--修改后台事务隔离边界

update t_job_trigger set FisolationBounsolationBoundary = '192.168.1.105'