RE: "AT" scheduler

Are you saying that Microsoft products don't come with useful documentation?

Documentation that can help you diagnose problems when things go wrong???

<gasp>

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada

> -----Original Message-----
> From: David Messer [SMTP:dmesser_at_prospective-health.com]
> Sent: Tuesday, April 03, 2001 5:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: "AT" scheduler
>
> I've gotten similarly odd performance from AT. I find that it, among
> other
> issues, doesn't do well if there are gaps in the list of job ids. For
> instance, if jobs are 1,2,3,19,20,21 (as a result of deleting and
> re-adding
> jobs) then jobs 1,2,and 3 run but not the others. Restarting the Schedule
> service seems to prompt a renumbering that seems to solve that problem.
> I've yet to see any documentation that explains the odd behavior.
>
> David
>
> -----Original Message-----
> Patrice J
> Sent: Tuesday, April 03, 2001 11:22 AM
> To: Multiple recipients of list ORACLE-L
>
>
> If you are running on NT, I strongly recommend you obtain crontab for
> Windows.
>
> AT will run 99.99% of the time... but not 100% of the time. On one of the
> servers here AT failed to run the very night that we were changing the
> time
> last Fall, very suspicious in my opinion.
>
> In any case for AT just do:
>
> at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program
>
> e.g.
> at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd
>
> That will create an entry:
> Added a new job with Job ID = <some number>
>
> To see the listing, just type AT [enter]
>
> To remove an entry,
>
> at ID_num /delete
> e.g.
> at 12 /delete
>
> Don't try to keep your jobs listing in any particular order, NT shuffles
> them around sometimes when you do maintenance on the server or when you
> reboot.
>
> For AT jobs to run, of course the Scheduler service must be running. The
> service has a couple of different names, depending on which service pack
> you
> installed on your server.
>
> Regards,
>
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
>
>
> > -----Original Message-----
> > From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> > Sent: Tuesday, April 03, 2001 1:30 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: "AT" scheduler
> >
> >
> > Can anyone tell me how to schedule a batch job to run every 5 minutes
> > using
> > the "AT" scheduler?
> >
> > Thanks!
> > --
> > 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: 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: David Messer
> INET: dmesser_at_prospective-health.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: 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).