Using xp_cmdshell

Question

Post reply

Using xp_cmdshell

Viewing 15 posts - 16 through 30 (of 52 total)

You must be logged in to reply to this topic. Login to reply

Anvie Ten Centuries Points: 1216 More actions · Answer 1

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"

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

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]

Anvie Ten Centuries Points: 1216 More actions · Answer 3

Anvie

Ten Centuries

Points: 1216

October 23, 2008 at 3:22 pm

#888907

it gives result to our SQL database.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

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]

Anvie Ten Centuries Points: 1216 More actions · Answer 5

Actually I suspect that... hmmm is there anyway I can kill the cmd.exe in SQL.

Thanks!

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

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 @dos

Who 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]

Jeff Moden SSC Guru Points: 1002844 More actions · Answer 7

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)

Jeff Moden SSC Guru Points: 1002844 More actions · Answer 8

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)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 9

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]

Jeff Moden SSC Guru Points: 1002844 More actions · Answer 10

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)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 11

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]

Jeff Moden SSC Guru Points: 1002844 More actions · Answer 12

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)

Anvie Ten Centuries Points: 1216 More actions · Answer 13

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. 😉

RBarryYoung SSC Guru Points: 143329 More actions · Answer 14

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]

Anvie Ten Centuries Points: 1216 More actions · Answer 15

Anvie

Ten Centuries

Points: 1216

October 24, 2008 at 8:30 am

#889262

yes I did...