BP转定时任务
-- 测试
declare @FullName varchar(100)
set @FullName='UFIDA.U9.Cust.IESLabBP.ARBillBP.UpdateRcvLineSHMoney'
delete from UBF_JOB_NoParaRunableBPSVList where FullName=@FullName
insert into UBF_JOB_NoParaRunableBPSVList([ID],[FullName],[Memo])
select s.[ID],s.[FullName],l.[DisplayName] from UBF_MD_Class s
left join UBF_MD_Class_Trl l on s.Local_ID=l.Local_ID and SysMLFlag='zh-CN'
where s.FullName=@FullName
调试定时任务
Untitled.png
