[AccessD] Scheduling an mdb to run using AT

What are you trying to run.  Is it just a data routine, or is it running
reports?  If it's just a data routine, I personally recommend using the NT
service OCX, which allows a VB .exe to run as an NT service.  Much easier to
deal with, shows up in the list of services, the ocx has an easy method to
dump information in the event viewer, etc.

Running reports can be done this way too, but it needs to use Automation.  

>From what I understand, VB.Net has the NT Service capability built in.

Drew

-----Original Message-----
From: Software Design & Solutions Pty Ltd.
To: AccessD at databaseadvisors.com
Sent: 5/8/03 10:08 PM
Subject: [AccessD] Scheduling an mdb to run using AT

Have any of you had much experience with scheduling applications to run
(ie. mdb files) using the AT command?
 
I am trying to get a job to run overnight for a client using the
following syntax:
 
at 14:26 /interactive /Every:M,T,W,Th,F cmd /c D:\Prices\Priceload.bat
 
where the files Priceload.bat contains the following:
  _____  

@ECHO OFF
REM Daily Price File Load
TITLE GBST PRICE LOAD
 
M:
cd \Price
echo ENTER PRICE FOLDER
ntsleep 2 > nul
 
Call Price.mdb

  _____  

 
I then get the message 'M:\Price\Price.mdb file not found'.
 
Because it is real PITN to keep mucking around with this syntax in DOS,
I am also having a play with some shareware(?) the client had called
WINAT. It seems good, but when I use it at my client site to edit the
paremeters of the AT command, extra characters appear at the end of the
command, so I am not sure whether the command will work or not.
Characters are things like pipes and @symbols. 
 
So my question for anyone using AT is: do you have any tips to share?
What is the most reliable way you have found to schedule an mdb to run?
 
TIA
Kath
 
 
Kath Pelletti
Software Design & Solutions Pty Ltd.
Ph: 9505-6714
Fax: 9505-6430
SDSSoftware at Optusnet.com.au <mailto:SDSSoftware at Optusnet.com.au> 
 <<ATT11462.txt>>