Using xp_cmdshell
-
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"
-
How do you know that the process actually completed, if it never returns?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
it gives result to our SQL database.
-
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.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Actually I suspect that... hmmm is there anyway I can kill the cmd.exe in SQL.
Thanks!
-
You might try this:
EXECUTE xp_cmdshell '"D:\Folder\Task.exe"'If that does not work, then try this:
Declare @dos varchar(4000)Select @dos = '"D:\Folder\Task.exe"' + Char(3) + ''EXECUTE xp_cmdshell @dosWho knows, it might work....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
CHAR(3)? Do you mean CHAR(13)?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
I'd be much more interesting in knowing what it is that "Task.exe" does and why you think it can't be done in T-SQL, whatever it is.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff Moden (10/23/2008)
CHAR(3)? Do you mean CHAR(13)?Nah, I've already got my Char(13)+Char(10)'s in the embedded line-breaks. Char(3) is Control-C.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
What does Ctrl-C do for this here?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
If the program is waiting for input from the command pipe that the SQL process used to issue the command, then a Control-C may cause it to exit. Now this works interactively for almost all DOS command-line programs that prompt for follow-on input or commands.
As to whether that would work for a piped-in command context like this, remember what I said:
rbarryyoung (10/23/2008)
You might try this:...
Who knows, it might work....
Only way to know is to try it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Dang... I forgot all about that. Thanks for the reminder.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Thanks guys, I monitor the task.exe and it open new cmd.exe that never terminated. now what I need to know is how to kill the cmd.exe using vb code.
-
anvieph (10/24/2008)
Thanks guys, I monitor the task.exe and it open new cmd.exe that never terminated. now what I need to know is how to kill the cmd.exe using vb code.Did you try both of the things that I posted above?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
yes I did...
Viewing 15 posts - 16 through 30 (of 52 total)
You must be logged in to reply to this topic. Login to reply