如何在sqlserver的定时任务中得到批处理执行后的返回值？

[minshengyinhang]

我在sqlserver的作业中利用定时任务,调用自己写的批处理脚本定时执行任务，sqlserver如何得到批处理执行后的返回值？

[-狙击手-]

1、写文件
2、写表
3、发邮件

[Limpire]

[Quote=引用 1 楼 happyflystone 的回复:]
1、写文件
2、写表
3、发邮件
[/Quote]

[华芸智森]

create table tab1 (f1 varchar(512))
insert into tab1 exec master.dbo.xp_cmdshell 'd:\\dd.bat'
select * from tab1
drop table tab1

------------------------


（所影响的行数为 2342 行）

f1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
C:\WINNT\system32>dir *.*
驱动器 C 中的卷没有标签。
卷的序列号是 64BF-59E9
NULL
C:\WINNT\system32 的目录
NULL
2008-05-04 09:39 <DIR> .
2008-05-04 09:39 <DIR> ..
2008-02-21 13:47 352 $winnt$.inf
1998-04-24 00:00 2,320 12500852.CPX
1998-04-24 00:00 2,318 12510866.CPX
2004-01-17 11:07 2,151 12520437.cpx
2004-01-17 11:07 2,233 12520850.cpx
1998-04-24 00:00 2,167 12520860.CPX
1998-04-24 00:00 2,162 12520861.CPX
1998-04-24 00:00 2,173 12520863.CPX
1998-04-24 00:00 2,147 12520865.CPX
2008-04-03 11:31 <DIR> 2052
2000-01-10 20:00 32,016 aaaamon.dll
2000-01-10 20:00 67,344 access.cpl
2002-08-29 09:25 64,512 acctres.dll
2003-06-19 12:05 150,800 accwiz.exe
2000-01-10 20:00 61,952 acelpdec.ax
2000-01-10 20:00 131,856 acledit.dll
2003-06-19 12:05 78,096 aclui.dll
2000-01-10 20:00 4,368 acsetupc.dll
2000-01-10 20:00 17,168 acsetups.exe
2000-01-10 20:00 11,536 acsmib.dll
2003-06-19 12:05 268,048 acssnap.dll
2000-01-10 20:00 51,200 acssnap.msc
2003-06-19 12:05 182,032 activeds.dll
2003-06-19 12:05 107,520 activeds.tlb
2000-01-10 20:00 26,384 actmovie.exe
2002-08-29 09:32 98,816 actxprxy.dll
2003-06-19 12:05 15,770,624 adminpak.msi
2000-01-10 20:00 39,184 admparse.dll
2000-01-10 20:00 32,528 admwprox.dll
2000-01-10 20:00 6,928 admxprox.dll
1998-05-07 00:00 113 ADODC.SRG
1998-07-07 00:00 14,336 ADODCCHS.DLL
2000-01-10 20:00 27,408 adptif.dll
2005-06-03 22:18 248,080 adsiis.dll
2003-06-20 07:44 6,416 adsiisex.dll
2005-06-03 22:18 130,832 adsldp.dll
2005-06-03 22:18 134,928 adsldpc.dll
2005-06-03 22:18 63,760 adsmsext.dll
2003-06-19 12:05 164,112 adsnds.dll
2003-06-19 12:05 201,488 adsnt.dll
2003-06-19 12:05 112,400 adsnw.dll
2005-06-03 22:18 401,168 ADVAPI32.DLL
2002-08-29 09:32 91,136 advpack.dll
2000-01-10 20:00 18,192 alrsvc.dll
2005-09-20 00:00 299,008 ALSNDMGR.CPL
2008-02-21 13:56 16,832 amcompat.tlb
2002-12-12 00:14 64,512 amstream.dll
2000-01-10 20:00 9,143 ansi.sys
2000-01-10 20:00 107,792 apcups.dll
2000-01-10 20:00 12,498 append.exe
2003-06-19 12:05 120,592 appmgmts.dll
2003-06-19 12:05 224,016 appmgr.dll
2003-06-19 12:05 301,328 appwiz.cpl
2000-01-10 20:00 19,728 arp.exe
2002-08-29 09:32 89,600 asctrls.ocx