Date:         Mon, 23 Jul 2007 17:33:43 -0600
Reply-To:     Alan Churchill <savian001@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <savian001@GMAIL.COM>
Subject:      Re: Invoking SAS from non SAS environment!
Comments: To: d@dkvj.biz
In-Reply-To:  <NIECJIJPHOLPKIFCPLHOEEPMKAAA.d@dkvj.biz>
Content-Type: text/plain; charset="iso-8859-1"

David,

Sysinternals was recently acquired by Microsoft. The old links should not be
applicable any longer.

Here is the new location for all Sysinternals.

http://www.microsoft.com/technet/sysinternals/default.mspx



Alan

Alan Churchill
Savian "Bridging SAS and Microsoft Technologies"
www.savian.net



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David
Johnson
Sent: Monday, July 23, 2007 5:29 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Invoking SAS from non SAS environment!

Either the national version of the M$ website is different here, or M$ has
done another of their "helpful" daily reorganisations of website content
Phil.

That link comes up as changed, and after a site search I got the following
suggestion.

http://www.microsoft.com/technet/sysinternals/utilities/psexec.mspx

Kind regards

David

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Phil
Rack
Sent: Tuesday, 24 July 2007 8:42 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Invoking SAS from non SAS environment!


Also check out PSEXEC at sysinternals. Extremely powerful utility with
boatloads of options.


Information about PsExec and downloads at:
http://www.sysinternals.com/Utilities/PsExec.html

Phil Rack
MineQuest, LLC
SAS Consulting and Contract Programming Services

Web: www.MineQuest.com
Tel: (614) 457-3714
Web Conference: SightSpeed
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Melvin Klassen
Sent: Monday, July 23, 2007 6:18 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Invoking SAS from non SAS environment!

> I have a situation at hand and would like to know if anybody has any
suggestion.
> There is a oracle database on a windows machine (say machine A)
> on which a trigger is written to detect a change to a particular
Oracle table.
> This trigger is then expected to invoke a SAS program on another
windows server (say machine B).
> SAS is installed only on machine B and therefore cannot be executed
directly from the machine A.
>
> However, I am facing problem in invoking a batchfile on another
machine (machine B)
> from a batch file on another machine (machine A).
>
> Can anybody help?

For Windows-to-Windows communication, use 'Netsh'.
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs
/en-us/netsh.mspx

Quote:

If you specify -r followed by another command,
netsh executes the command on the remote computer,
and then returns to the Cmd.exe command prompt.

/Quote:



So, you can run a '.bat' file on the remote computer, and that file
could invoke SAS.

  ... Melvin