| 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: Using AT command in NT
We keep a batch script in the same location on each NT server. The batch
has all the scheduled AT jobs in it.
If one needs to be changed we can change the batch file and then execute it
from the DOS prompt or explorer.
The script deletes everything from the AT schedule and then reschedules
everything in the batch file. This
way we don't have to remember what was scheduled when and what was the
syntax.
Example:
at /delete
at 20:00 /every:M,T,W,TH,F d:\datatools\xrt1hot.bat at 21:00 /every:M,T,W,TH,F d:\datatools\xrt2hot.bat at 22:00 /every:M,T,W,TH,F
at 11:30 /every:M,T,W,TH,F c:\dbastuff\xrt1_prod\DBA\impexp\exp_xrtuser.bat at 11:55 /every:M,T,W,TH,F c:\dbastuff\xrt1_prod\DBA\batch\dbcopy.cmd at 23:00 /every:M,T,W,TH,F c:\dbastuff\xrt1_prod\DBA\impexp\exp_xrtuser.bat at 23:55 /every:M,T,W,TH,F c:\dbastuff\xrt1_prod\DBA\batch\dbcopy.cmd at 23:30 /every:M,T,W,TH,F c:\dbastuff\xrt2_test\DBA\impexp\exp_xrtuser.bat at 01:00 /every:M,T,W,TH,F
at 07:00 /every:M,T,W,TH,F c:\dbastuff\xrt1_prod\dba\batch\scanlog.bat at 14:10 /every:M,T,W,TH,F d:\gl_interface\CHEM\gl_interface_chem.bat at 14:10 /every:M,T,W,TH,F d:\gl_interface\CORP\gl_interface_corp.bat at 15:10 /every:M,T,W,TH,F d:\AP_Interface\APCC_interface\apxrt.bat at 15:15 /every:M,T,W,TH,F d:\ftp_xrt\moveapep.bat at 15:20 /every:M,T,W,TH,F d:\AP_Interface\APEP\AP_interface_EP.bat at 23:00 /every:F c:\batch\full.cmd at 23:00 /every:M,T,W,TH,S,SU c:\batch\incrmntl.cmdpause
Ron Smith
Database Administrator
rlsmith_at_kmg.com
-----Original Message-----
Sent: Wednesday, August 01, 2001 3:23 PM
To: Multiple recipients of list ORACLE-L
You probably know, just make sure your Schedule service is running...
; )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
-----Original Message-----
From: George Hofilena [SMTP:GHofilena_at_cnv.org]
Sent: Wednesday, August 01, 2001 5:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Using AT command in NT
Try,
at 12:00pm /every:m,t,w,th,f c:\my_backups\backup.bat
George
-----Original Message-----
Sent: Wednesday, August 01, 2001 11:28 AM
To: LazyDBA.com Discussion
I'm looking into setting up my backups and want to use the AT
command in NT
but I need some examples of the command line.
I Know that I want it daily at midnight,but how do I do this in
command line
mode, What is the command?
This is what I have tried and it does'nt work.
AT /every:date M,T,W,TH,F 12:00pm "c:\my_backups" -- this does not
work.
Help please
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to
oracledba-unsubscribe_at_LAZYDBA.com
To subscribe: send a blank email to
oracledba-subscribe_at_LAZYDBA.com
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Hofilena
INET: GHofilena_at_cnv.org
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: Boivin, Patrice J INET: BoivinP_at_mar.dfo-mpo.gc.ca 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: 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).Received on Wed Aug 01 2001 - 14:40:45 CDT
 |
 |