Does anyone know offhand how I could remotely execute a further process on
the NT box?

We solved that problem in a different way. Suits us, might not suit
everyone.

The NT system has a scheduling system which can be run from the command
prompt.
The command is "C:\WINNT\System32\AT.EXE". (As in ":stream jobname ;AT=
23:00".)
The syntax is a bit labourious.

But ....
There is also an gui version of AT.EXE called WINAT.EXE which comes on a
ressource kit CD.

So ...
I set up the WINAT prog to run every day at a certain time and execute
certain .BAT (or .CMD) command files on the NT machine. These command files
do whatever I want done on the files received from the HP3000. The
synchronisation is, well, loose :
I assume that all the files will have landed by 06:00 which is when my
command files do their thing.


Admittedly ...
This is no good when you want to do something immediately with the new files
as soon as they land on the NT machine. But this is not the case with us.


Other ideas ...
You could initiate the FTP tranfer from the NT machine from a command file
that would then continue on with some other work on the transferred files
once they arrived. You can run FTP with a script (c:\windows\ftp.exe
xxx.xxx.xxx.xxx -s:script.txt.)

Perhaps there is some neat way to get Reflection to wait for a TELL message
at the end of a job and then execute a Refection script containing commands
?

----------
This next bit may seem O.T. but it's one case of scrapping the need to
execute the commands. May interest someone ...

Our HP3000 gathers data every night and FTP's it all accross to an NT
server.
The data is prepared in CSV format (fields with separators) before transfer.
And that's it. We don't execute anything at this point.

For presenting the data in user-friendly readable tables with ratios etc. we
use Excel. OK, so how does the Excel spreadsheet get updated ?

The Excel spreadsheet contains a Pivot Table and has ben saved (once and for
all) as a template (.XLT) that automatically updates itself - via ODBC - the
with the newly arrived CSV data whenever it is opened.

When we discovered this Excel feature we no longer needed to worry about
remotely running Excel-with-a-macro from the MPE job so that it would update
itself with the new data. No more worrying about synchronising between
delivery and execution because there is no execution.

The Excel tables are updated once a day, available to all and ..., it saves
paper.

When we get the new A400 we wil try to get Excel to read the data directly
from the HP3000 using Samba ...

If you want any more on this : [log in to unmask] or to the group, up
to you.
-----------------

Seamus

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *