...不要把简单问题复杂化,非要把两个简单问题合并成一个复杂问题,给两个办法 1 sql里查询时间 直接用xp_cmdshell 'md 目录' 2 调用bat文件,bat文件里用脚本建目录f: cd\ cd test if /i %time:~0,2% lss 10 set abc=backup%date:~0,8%_%time:~1,1%_%time:~3,2% if /i not %time:~0,2% lss 10 set abc=backup%date:~0,8%_%time:~0,2%_%time:~3,2% md %abc% cd %abc% "E:\cwrsync\Server\bin\rsync.exe" -vzrtp --delete [email protected]::backup . cd\当前的时间如果是2008.6.9 15:15,则生成的目录名是backup080609_1515
1 sql里查询时间 直接用xp_cmdshell 'md 目录'
2 调用bat文件,bat文件里用脚本建目录f:
cd\
cd test
if /i %time:~0,2% lss 10 set abc=backup%date:~0,8%_%time:~1,1%_%time:~3,2%
if /i not %time:~0,2% lss 10 set abc=backup%date:~0,8%_%time:~0,2%_%time:~3,2%
md %abc%
cd %abc%
"E:\cwrsync\Server\bin\rsync.exe" -vzrtp --delete [email protected]::backup .
cd\当前的时间如果是2008.6.9 15:15,则生成的目录名是backup080609_1515