作业执行失败:
看了一下执行脚本
delete top(8000) from "interface"."完成" where loggid in(
select loggid from "interface"."完成20150601"
)
然后再sqlserver query执行一下,发现是可以成功的.然后执行语句
set QUOTED_IDENTIFIER ON
再执行作业还是失败的,然后将脚本改为
set QUOTED_IDENTIFIER ON
delete top(8000) from "interface"."完成" where loggid in(
select loggid from "interface"."完成20150601"
)
修改作业,然后就发现,可以执行成功了.