1)IF DAY(GETDATE()) <> 2
BEGIN
delete r1001b where mm = convert(char(4),year(getdate() - 1)) + 'M' +
right('0' + convert(varchar(2),month(getdate() - 1)),2)
end
2)\\192.168.12.12\ftp$\csv\r1001b\migratedata.bat
3)DTSRUN /E /S "(LOCAL)" /N "R1001B"
4)DTSRUN /E /S "(LOCAL)" /N "cmmstr"
5)DTSRUN /E /S "(LOCAL)" /N "ptmstr"
6)DTSRUN /E /S "(LOCAL)" /N "pimstr"
7)
Declare @fm Varchar(10)
Set @fm=(Select Convert(Varchar(4),year(DateAdd(month,-3,getdate() - 1))) + 'F'
+ right('0' + Convert(Varchar(2),month(DateAdd(month,-3,getdate() - 1))),2))
Execute ('Pc2t_R1001B '''+ @fm+'''')
8)Execute ('PV2t_R1001B')
9)\\192.168.12.12\ftp$\csv\r1001b\r1001brestore.bat
备注:DTSRUN的作业类型为操作系统命令(CmdExec)