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 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: [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).

Reply via email to