launching an application from URS

[victor]

Dear all,

a quick and painless question:

I need to launch a batch file from within a strategy. Can this be done without using custom server?

We are talking about solaris, and I am not too keen on programming.

Thanks,
Vic

[Haldane]

I tried to do something like this in 6.5 but could only do it through a custom server. I then found an easier way via a stored porc. It was on Oracle so I used the DBMS.PIPE command, in which you can pipe out an OS command. Not sure how to do this in SQLserver. Maybe ask your DBA.

[victor]

Launching something through a stored procedure in Oracle. 

This is something I can imagine doing. I wonder the stored procedure would be in SQL server...

[LeszekM]

In MS SQL you have got the "xp_cmdshell" system extended stored procedure.

Regards
Leszek

[cavagnaro]

Awesome! This can solve a $4000 develpment Genesys was trying to sell me! Will try ASAP!

[victor]

Ok, thanks to everyone, I figured out a solution

xp_cmdshell does the trick.

Here is how it works:

exec master.dbo.xp_cmdshell 'copy c:\temp\a.txt c:\temp\workfile.txt'

this will copy a.txt into workfile.txt

if you need to analyze return value, then try this:

DECLARE @rc int
EXEC @rc = master.dbo.xp_cmdshell 'copy c:\temp\a.txt c:\temp\workfile.txt'
print @rc
IF @rc <> 0
BEGIN
  PRINT 'Copy Failed'
END
ELSE
BEGIN
  Print 'Copy worked'
  ....
END


And then, all you need to do is call it from URS. I think you know how to do this, so I will let you be.
In case you don't here we go: