<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Haidong Ji
»
Using xp_cmdshell
53 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
Using xp_cmdshell
Rate Topic
Display Mode
Topic Options
Author
Message
RBarryYoung
RBarryYoung
Posted Saturday, July 26, 2008 1:07 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
Please provide examples of your code for those cases where the CMD.EXE's are hanging around.
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #541437
kivancimer
kivancimer
Posted Saturday, August 02, 2008 4:19 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 07, 2011 1:46 AM
Points: 2,
Visits: 11
Thanks for response but i have figured out the problem.it was about bad exception handling.
Post #545617
anvie
anvie
Posted Thursday, October 23, 2008 2:24 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, June 14, 2012 3:37 PM
Points: 34,
Visits: 110
I have the same problem. My cmd.exe left open even the processes is already completed.
EXECUTE xp_cmdshell '"D:\Folder\Task.exe" & exit'
Can you please help me to solve this.
Thanks!
Post #590787
RBarryYoung
RBarryYoung
Posted Thursday, October 23, 2008 2:35 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
When I try to execute this I get "The system cannot find the path specified."
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #590795
RBarryYoung
RBarryYoung
Posted Thursday, October 23, 2008 2:42 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
By the way, I would not use the " & Exit". It should not be necessary and it may be what is causing your problem.
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #590800
anvie
anvie
Posted Thursday, October 23, 2008 2:44 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, June 14, 2012 3:37 PM
Points: 34,
Visits: 110
I tried this but still give me the same problem. everything run ok it juts leave the cmd open
EXECUTE xp_cmdshell '"D:\Folder\Task.exe"
Post #590802
RBarryYoung
RBarryYoung
Posted Thursday, October 23, 2008 3:09 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
How do you know that the process actually completed, if it never returns?
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #590820
anvie
anvie
Posted Thursday, October 23, 2008 3:22 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, June 14, 2012 3:37 PM
Points: 34,
Visits: 110
it gives result to our SQL database.
Post #590826
RBarryYoung
RBarryYoung
Posted Thursday, October 23, 2008 3:26 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
That does not mean that it is completed. It could be still hanging around trying to read command input from somewhere or something (that will never come, obviously). It all depends on how your "Task.exe" command is written.
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #590829
anvie
anvie
Posted Thursday, October 23, 2008 3:29 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, June 14, 2012 3:37 PM
Points: 34,
Visits: 110
Actually I suspect that... hmmm is there anyway I can kill the cmd.exe in SQL.
Thanks!
Post #590833
« Prev Topic
|
Next Topic »
53 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
