如何知道sql server 2008中的xp_cmdshell是否崩溃 [英] How to know whether xp_cmdshell in sql server 2008 crashes or not

问题描述

大家好，





如何知道sql server 2008中的xp_cmdshell是否崩溃，

i在多个程序中使用了这个xp_cmdShell，但有时它崩溃而且无法正常工作，因为我需要在xp_cmdshell崩溃时发送电子邮件，任何正文可以帮助我如何知道xp_cmdShell的崩溃









谢谢和问候

Sudheer.N

解决方案

崩溃是什么意思？ xp_cmdshell 没有崩溃，所以你的陈述没有任何意义。



确实，但是，根据命令是否成功启动，返回0或1。它不会告诉你它启动的命令是否成功执行。



OH，为了将来的参考，你可能想要阅读这些 [ ^ ]。

Hi All,


How to know whether xp_cmdshell in sql server 2008 crashes or not,
i used this xp_cmdShell in multiple procedures but some times it is crashes and not working , for that i need to send an email when the xp_cmdshell is crashed, can any body help me how can i know the crashes of xp_cmdShell




Thanks & Regards
Sudheer.N

解决方案

What do you mean by "crashes"?? xp_cmdshell doesn''t crash, so your statement doesn''t make any sense.

It does, however, return a 0 or 1 depending on if the command was successfully launched. It does NOT tell you if the command it launched was executed successfully or not.

OH, and for future reference, you might want to read these[^].

这篇关于如何知道sql server 2008中的xp_cmdshell是否崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！