Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Windohs - monthly at job

RE: Windohs - monthly at job

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 08 Jul 2003 10:21:04 -0700
Message-ID: <F001.005C3E0A.20030708101424@fatcity.com>

OK
now, for fun, schedule through AT a job that will run every fifteen minutes between 6AM and 8PM on Mondays through Fridays. <FONT face=Arial color=#0000ff
size=2> 
:
)
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>Patrice.

<FONT face=Tahoma

  size=2>-----Original Message-----From: Branimir Petrovic   [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 2:45   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   Windohs - monthly at job
  Jerry,
  t<SPAN
  class=231441616-08072003>o schedule "something" on local or remote   Win2K computer:
<SPAN

  class=231441616-08072003> 
  Simple
  (preferred), non-GUI way:
<SPAN

  class=231441616-08072003>================================

<SPAN

  class=231441616-08072003> 

<SPAN

  class=231441616-08072003>C:>at <A
  href="file://%25ComputerName%25/"><FONT   size=2>\\%ComputerName% 23:00
  /every:15 C:<SPAN
  class=231441616-08072003>\myJob.bat
<SPAN

  class=231441616-08072003> 
  To see
  what's been scheduled:
<SPAN

  class=231441616-08072003> 
<SPAN

  class=231441616-08072003>C:\>atStatus ID  

  Day                     

  Time          Command
  Line-------------------------------------------------------------------------------        
  1   Each
  1                  
  11:00 PM      
  C:\myJob.bat        2   Each 
  15                 

  11:00 PM      C:\myJob.bat
<SPAN

  class=231441616-08072003> 
  Do not
  specify \\%ComputerName% - and the job   is scheduled locally.
  The above
  is also visible from GUI Task Scheduler.
<SPAN

  class=231441616-08072003> 
<SPAN

  class=231441616-08072003> 
  Other way
  (to do the same):
<SPAN
  class=231441616-08072003>==========================
  By
  leveraging WMI (hideously complex & ugly COM object hierarchy) that Win2K   

  comes
  equipped <SPAN
  class=231441616-08072003>with and by using "scripting for 21st   century" the VB Script.
<SPAN

  class=231441616-08072003> 
  For how
  to it (use M$ scripting) do - see the TechNet Script Center<FONT   color=#ffffff>r
<A

  href="http://www.microsoft.com/technet/treeview/default.asp?url="">http://www.microsoft.com/technet/treeview/default.asp?url="">
<SPAN

  class=231441616-08072003> 
  Section
  on "Task Scheduling":
<A

  href="http://www.microsoft.com/technet/treeview/default.asp?url="">http://www.microsoft.com/technet/treeview/default.asp?url="">
<SPAN

  class=231441616-08072003> 
<SPAN

  class=231441616-08072003> 
  Now,
  let's talk abt. virtual pint... ;-)
<SPAN

  class=231441616-08072003> 
<SPAN

  class=231441616-08072003>Branimir
<BLOCKQUOTE dir=ltr

  style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">     <FONT
    size=2> -----Original
    Message-----From: Cunningham, Gerald     [mailto:[EMAIL PROTECTED]Sent: July 8, 2003 12:39     PMTo: Multiple recipients of list ORACLE-LSubject:     Windohs - monthly at job
    Hi
    all,
    <SPAN
    class=230243915-08072003> 
    Does anybody
    know the syntax to schedule a monthly "at" job on Windows (2000)? I need to     schedule a job for the 1st and 15th every month, and would like to avoid the     Task Scheduler GUI.
    <SPAN
    class=230243915-08072003> 
    A virtual pint
    o' Guiness (mmmmmm...) for anybody who can help!     <SPAN
    class=230243915-08072003> 
    <SPAN
    class=230243915-08072003>Thanks!
    <SPAN
    class=230243915-08072003> 
    -
    Jerry
    <FONT color=#0000ff
size=2>  Received on Tue Jul 08 2003 - 12:21:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US