insert into tphy_fph_lis(fph,djlx,bz,jcxmdm,sl,je,sj,fpsycs,fpsycsmax,xm,xb,nl,kjks,kjksmc,ysdm,ysmc)
select fph,'01',mzbz,xmdm,sl,je,sj,0,1,xm,xb,nl,' ',ksmc,' ',ysmc
from openquery (hh,'select fph,''01'',mzbz,xmdm,sl,je,sj,0,1,xm,xb,nl,'' '',ksmc,'' '',ysmc from view_lis_mz') a
WHERE not exists (SELECT * FROM TPHY_FPH_LIS WHERE FPH=A.FPH AND JCXMDM=A.XMDM AND XM=A.XM AND SJ=A.SJ)
GO
insert into tphy_fph_lis(fph,djlx,bz,jcxmdm,sl,je,sj,fpsycs,fpsycsmax,xm,xb,nl,kjks,kjksmc,ysdm,ysmc)
select fph,'01',zybz,xmdm,sl,je,sj,0,1,xm,xb,nl,' ',ksmc,' ',ysmc
from openquery (hh,'select fph,''01'',zybz,xmdm,sl,je,sj,0,1,xm,xb,nl,'' '',ksmc,'' '',ysmc from view_lis_zy') a
WHERE not exists (SELECT * FROM TPHY_FPH_LIS WHERE FPH=A.FPH AND JCXMDM=A.XMDM AND XM=A.XM AND SJ=A.SJ)
这是我在作业里写的! 为什么不能运行呢???
请高人指点!!! 谢谢!!
select fph,'01',mzbz,xmdm,sl,je,sj,0,1,xm,xb,nl,' ',ksmc,' ',ysmc
from openquery (hh,'select fph,''01'',mzbz,xmdm,sl,je,sj,0,1,xm,xb,nl,'' '',ksmc,'' '',ysmc from view_lis_mz') a
WHERE not exists (SELECT * FROM TPHY_FPH_LIS WHERE FPH=A.FPH AND JCXMDM=A.XMDM AND XM=A.XM AND SJ=A.SJ)
GO
insert into tphy_fph_lis(fph,djlx,bz,jcxmdm,sl,je,sj,fpsycs,fpsycsmax,xm,xb,nl,kjks,kjksmc,ysdm,ysmc)
select fph,'01',zybz,xmdm,sl,je,sj,0,1,xm,xb,nl,' ',ksmc,' ',ysmc
from openquery (hh,'select fph,''01'',zybz,xmdm,sl,je,sj,0,1,xm,xb,nl,'' '',ksmc,'' '',ysmc from view_lis_zy') a
WHERE not exists (SELECT * FROM TPHY_FPH_LIS WHERE FPH=A.FPH AND JCXMDM=A.XMDM AND XM=A.XM AND SJ=A.SJ)
这是我在作业里写的! 为什么不能运行呢???
请高人指点!!! 谢谢!!
作业不运行, 一般是计划不合理, 导致没有可以运行的时间点, 另外, 也可能是你根本没有设置 作业的执行计划
或者是你的 sqlserveragent 服务没有启动
再看代理服务器启动了没有。
然后手工启动作业看看,是否完成成功。通过这三步骤检查就可以找出问题地方。
代理服务器也打开了
手工启动 启动不了"划不合理, 导致没有可以运行的时间点,也可能是你根本没有设置 作业的执行计划"
这句话是什么意思?