| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: NT Batch processes continue to run
Hello,
How are you scheduling your batches? You should be using CMD /C.
For example:
AT 7:00P /EVERY M,T,W,TH,F,S,SU CMD /C C:\BACKUP\BACKORCL.BAT
C:\>cmd /?
Starts a new instance of the Windows/NT command interpreter
CMD [/X | /Y] [/A | /U] [/Q] [[/C | /K] string]
/C Carries out the command specified by string and then terminates /K Carries out the command specified by string but remains /Q Turns the echo off /A Causes the output of internal commands to a pipe or file to be ANSI /U Causes the output of internal commands to a pipe or file to beUnicode
/T:fg Sets the foreground/background colors (see COLOR /? for more info) /X Enable extensions to the Windows NT version of CMD.EXE /Y Disable extensions to the Windows NT version of CMD.EXE
-- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: chris.guidry_at_atcoelectric.comReceived on Thu Mar 15 2001 - 16:23:43 CST
> -----Original Message-----
> From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> Sent: Thursday, March 15, 2001 12:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: NT Batch processes continue to run
>
> We have several NT Dos batch scripts that execute sql statements, copy NT
> files, send email, etc..... For some reason after a couple of weeks the
> NT
> server slows to a crawl. We look at the running process and there are
> dozens of EXE and CMD processes running. The batch scripts are scheduled
> to
> run each day and complete normally. Any idea why the processes don't end?
>
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: chris.guidry_at_atcoelectric.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |