|
Bob: I have an
application that runs every night at 11:30 PM. It reads a text file generated
by another system parses the data and then inserts the appropriate values into
3 different tables doing data integrity checks, it has been running reliably
for almost a year. A couple
of thing to check Does a
user need to be logged in and have access privileges? Does the network
have scheduled routine maintenance that would disconnect the user or other wise
conflict in time with your application? One way to
check your code is to place the commands: SET
MESSAGES ON SET ERROR
MESSAGES ON SET DEBUG
ON DEBUG
TRACE At the top
of you code and schedule it to start in a couple of minutes. When it starts it
will be in the TRACE mode and then you can execute the commands one line at a
time and hopefully you will see where you problem is as all messages will be
displayed. If you are running the Scheduler under Windows XP, I believe that it
is required that the workstation have a login and password, otherwise it will
not execute. Javier, Javier Valencia, PE President Valencia
Technology Group, L.L.C. 14315 S.
Twilight Ln, Suite #14 Olathe, Kansas
66062-4578 Office
(913)829-0888 Fax (913)649-2904 Cell
(913)915-3137 ================================================ Attention: The information
contained in this message and or attachments is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any
review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this in error, please contact the sender and delete the
material from all system and destroy all copies. ====================================================== -----Original
Message----- Any one have an idea why a command file
would run fine from an R> but not from the task scheduler? I have a
command file that I have set to run every hour in the scheduler.
When the scheduler runs the file, everything seems to work OK but an
insert command does not execute. (Does not give an error, nor does it
insert the records) If I run the same file from the R>, the
insert command executes fine. I get no errors, the insert simply does not
work. This is a real puzzler for me. Thanks, -Bob |
- [RBG7-L] - RE: Scheduled Task puzzle Javier Valencia
- [RBG7-L] - RE: Scheduled Task puzzle ttc . inc
