RE: Using AT command in NT
Hello, Why don't you use the IExplorer Task Scheduler? It comes standard with IE5 or is an add-on for IE4. Look in "My Computer" for Scheduled Tasks. I find it less of a PITA than AT or WinAT. It also lets you schedule batches to run at almost any interval as opposed to having the AT command reschedule itself. The AT command syntax is: AT 7:00P /EVERY M,T,W,TH,F,S,Su CMD /C C:\BACKUP\BACKUP.BAT -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] > -Original Message- > From: George Hofilena [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 02: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 > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > > Oracle documentation is here: > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage > To unsubscribe: send a blank email to [EMAIL PROTECTED] > To subscribe: send a blank email to [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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
c:\dbastuff\xrt1_prod\dba\batch\delete_old_backups.bat
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
c:\dbastuff\xrt1_prod\dba\batch\delete_cashint.bat
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.cmd
pause
Ron Smith
Database Administrator
[EMAIL PROTECTED]
-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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-Original Message-
From: George Hofilena [SMTP:[EMAIL PROTECTED]]
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
_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to
[EMAIL PROTECTED]
To subscribe: send a blank email to
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of m
RE: Using AT command in NT
or try winat and get a window version of it.. -Original Message- Sent: Wednesday, August 01, 2001 4:04 PM To: Multiple recipients of list ORACLE-L 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Using AT command in NT
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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- From: George Hofilena [SMTP:[EMAIL PROTECTED]] 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
